Q18
Single choice
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?