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

Question

Options

• ASELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING
• BSELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY
• CSELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• DSELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;
• ESELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY

• A
  71% (34)
• B
  4% (2)
• D
  8% (4)
• E
  17% (8)

No community discussion yet for this question.