Which of the following is the correct query to get the order$\_$id from the order$\_$items table for the products having a product$\_$price greater than $$8500?$ SQL query

Select only one option

SELECT

ORDER$\_$ID

FROM ORDER$\_$ITEMS

WHERE PRODUCT$\_$ID $=($SELECT

PRODUCT$\_$ID

FROM PRODUCT

WHERE PRODUCT$\_$PRICE $>8500)$;

SELECT

ORDER$\_$ID

FROM ORDER$\_$ITEMS

WHERE PRODUCT$\_$ID NOT IN $($SELECT

PRODUCT$\_$ID

FROM PRODUCT

WHERE PRODUCT$\_$PRICE $>8500)$;

SELECT

ORDER$\_$ID

FROM ORDER$\_$ITEMS

WHERE PRODUCT$\_$ID IN $($SELECT

PRODUCT$\_$ID

FROM PRODUCT

WHERE PRODUCT$\_$PRICE $>8500)$;