【多选题】
A SELECT COUNT (prod_id) FROM sales GROUP BY prod id WHERE quantity_ sold > 55000;
B SELECT COUNT (prod_id) FROM sales WHERE quantity sold > 55000 GROUP BY prod_ id;
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 > SS000 AND COUNT(*)>10 GROUP BY Prod_id HAVINGCOUNT(*)>10;
E SELECTprod_id FROM sales WHERE quantity_sold>55000 GROUR BY prod_id HAVING COUNT(*)>10;
查看更多
