【多选题】
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 GROUPBYCOUNT(*)>10;
D SELECT prod_id FROM sales WHERE quantity_sold >55000 GROUP BY prod id HAVINGCOUNT(*)>10;
E SELECT COUNT (prod_id) FROM sales WHERE quantity_sold>55000 GROUP BY prod_id;
查看更多
