请评估如下的SQL语句： SELECT manufacturer_id, CO
题型：单项选择题
问题：
请评估如下的SQL语句：
SELECT manufacturer_id, COUNT(*), order_date
FROMinventory
WHEREprice＞5.00
GROUP BY order_date, manufacturer_id
HAVING COUNT(*)＞10
ORDER BY order_date DESC;
在以上的查询语句中，指定从INVENTORY(库存)表中返回哪些行的子句是哪个
A．SELECT manufacturer_id, COUNT(*), order_date
B．WHERE price＞5.00
C．GROUP BY orderdate, manufacturer_id
D．ORDER BY order_date DESC
E．HAVING COUNT(*)＞10