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

A) SELECT COUNT (prod_id) FROM sales
WHERE quantity_sold > 55000
GROUP BY prod_id;
B) SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id
HAVING COUNT(*) > 10;
C) SELECT prod_id FROM sales WHERE quantity sold > 55000 AND COUNT(*) > 10
GROUP BY prod_id
HAVING COUNT(*) > 10;
D) SELECT COUNT (prod_id) FROM sales
GROUP BY prod_id
WHERE quantity_sold > 55000;
E) SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10
GROUP BY COUNT(*) > 10;