Which of the following is the correct query to get the average price at product$\_$class$\_$code for products having a product$\_$price greater than the average product$\_$price? In SQL QUERIES

Select only one option

SELECT PRODUCT$\_$CLASS$\_$CODE, AVG$($PRODUCT$\_$PRICE$)$ AS AVG$\_$PRICE

FROM PRODUCT

WHERE PRODUCT$\_$PRICE $>($

SELECT AVG$($PRODUCT$\_$PRICE$)$

FROM PRODUCT$)$

GROUP BY PRODUCT$\_$CLASS$\_$CODE;

SELECT PRODUCT$\_$CLASS$\_$CODE, PRODUCT$\_$PRICE

FROM PRODUCT

WHERE PRODUCT$\_$PRICE $>($

SELECT AVG$($PRODUCT$\_$PRICE$)$

FROM PRODUCT$)$

GROUP BY PRODUCT$\_$CLASS$\_$CODE;

SELECT PRODUCT$\_$CLASS$\_$CODE, AVG$($PRODUCT$\_$PRICE$)$ AS AVG$\_$PRICE

FROM PRODUCT

WHERE PRODUCT$\_$PRICE $<($

SELECT AVG$($PRODUCT$\_$PRICE$)$

FROM PRODUCT$)$

GROUP BY PRODUCT$\_$CLASS$\_$CODE;