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 orderjtems
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?

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 orderjtems
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.
Replace = with the >ALL operator.

B.
Replace = with the >ANY operator.

C.
Replace = with the IN operator.

D.
Remove the GROUP BY clause from the subquery and place it in the main query.

Show Hint