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?

Question

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?

Accepted Answer

D. Replace = with the IN operator

Answer

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

Answer

B. Replace = with the >ANY operator

Answer

C. Replace = with the >ALL operator

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…

Question

Exhibit

Options

How the community answered

Community Discussion