Scenario: In a Products table with columns CategoryID, Price, and ProductName, which SQL query would retrieve product categories with more than $5$ products and an average price greater than $50?$

Context:

Products Table Columns:

ProductID

CategoryID

Price

ProductName

A

SELECT CategoryID, COUNT$($ProductID$)$ as ProductCount, AVG$($Price$)$ as AvgPrice FROM Products GROUP BY CategoryID HAVING ProductCount $>5$ AND AvgPrice $>50$;

B

SELECT $*$ FROM Products GROUP BY CategoryID HAVING COUNT$($ProductID$)>5$ AND AVG$($Price$)>50$;

C

SELECT CategoryID, Price FROM Products HAVING COUNT$($ProductID$)>5$ AND AVG$($Price$)>50$;

D

SELECT $*$ FROM Products HAVING COUNT$($ProductID$)>5$ AND AVG$($Price$)>50$;