为自己加油

The SALES table has columns PROD_ ID and QUANTITY SOLD of data type NUMBER.
Which two queries execute successfully?

A.SELECT  prod  id  FROM  sales  WHERE  quantity  sold  >55000  AND  COUNT(*)>  10  GROUP
BYprod id HAVING COUNT(*)>10:
B.SELECT COUNT (prod iD.FROM sales GROUP BY prod id WHERE quantity_sold >55000
C.SELECT prod id FROM sales WHERE quantity sold >55000 AND COUNT(*)>10 GROUP BY
COUNT(*)>10:
D.SELECT prod id FROM sales WHERE quantity sold >55000 GROUP BY prod id HAVING
COUNT (*)>10;
E.SELECT COUNT (prod iD.FROM sales WHERE quantity_sold >55000 GROUP BY prod id;