Which of the following is the correct query to get the product details $($product$\_$id and product$\_$price$)$ for the products having prices ranged between average price and $50000$ from the product table? SQL QUERY

Select only one option

SELECT

PRODUCT$\_$ID$,$

PRODUCT$\_$PRICE

FROM PRODUCT

WHERE PRODUCT$\_$PRICE $=($

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

FROM PRODUCT

$)$

AND $50000$

ORDER BY PRODUCT$\_$PRICE;

SELECT

PRODUCT$\_$ID$,$

AVG$($PRODUCT$\_$PRICE$)$ AS AVERAGE$\_$PRICE

FROM PRODUCT

WHERE PRODUCT$\_$PRICE BETWEEN $($

SELECT PRODUCT$\_$PRICE

FROM PRODUCT

$)$

AND $50000$

ORDER BY PRODUCT$\_$PRICE;

SELECT

PRODUCT$\_$ID$,$

PRODUCT$\_$PRICE

FROM PRODUCT

WHERE PRODUCT$\_$PRICE BETWEEN $($

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

FROM PRODUCT

$)$

AND $50000$

ORDER BY PRODUCT$\_$PRICE;