What correction should be made in the above SQL statement to achieve this?

View the Exhibit and examine the structure of the ORDER_ITEMS table.

Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price =
(SELECT MAX(unit_price)
FROM order_items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest UNIT_PRICE per ORDER_ID. What correction should be made in the above SQL statement to achieve this?
A. Remove the GROUP BY clause from the subquery and place it in the main query
B. Replace = with the >ANY operator
C. Replace = with the >ALL operator
D. Replace = with the IN operator

Download Printable PDF. VALID exam to help you PASS.