第 11 题 (多选题)： The SALES table has columns PROD_ ID and QUANTITY_SOLD of data type NUMBE. Which two queries execute successfully.

A. SELECT prod_id FROM sales WHERE quantity_sold >55000 AND COUNT(*)> 10 GROUP BY prod_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; 显示答案