Q121 The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully?

Q121 The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully?

• (A). SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(*) > 10;
• (B). SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;
• (C). SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• (D). SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;
• (E). SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) > 10;