The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries execute successfully? (Choose two.)

Question

Options

• ASELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING
• BSELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY
• CSELECT COUNT (prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• DSELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY
• ESELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;

• A
  83% (25)
• B
  3% (1)
• D
  10% (3)
• E
  3% (1)

No community discussion yet for this question.