Scenario: In a database with a Products table containing columns ProductID, CategoryID, and Price, which SQL query would create a view named CategoryAverages to retrieve the average price for each product category?

Context:

Products Table Columns:

ProductID

CategoryID

Price

A

CREATE VIEW CategoryAverages AS

SELECT CategoryID, AVG$($Price$)$ AS AvgPrice

FROM Products

GROUP BY CategoryID;

B

CREATE VIEW CategoryAverages AS

SELECT $*$

FROM Products

GROUP BY CategoryID, AVG$($Price$)$;

C

CREATE VIEW CategoryAverages $($CategoryID$,$ AvgPrice$)$ AS

SELECT $*$

FROM Products

GROUP BY CategoryID, AVG$($Price$)$;

D

CREATE VIEW CategoryAverages AS

SELECT CategoryID, Price

FROM Products

WHERE AVG$($Price$)>0$;