Which query would produce the desired output?

Prev Question
Next Question

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

Exam 1Z0-047 - Which query would produce the desired output?

You need to display the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.

Which query would produce the desired output?

A.
SELECT order_id
FROM order_items
WHERE(unit_price*quantity) = MAX(unit_price*quantity) GROUP BY order_id;

B.
SELECT order_id
FROM order_items
WHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items)
GROUP BY order_id;

C.
SELECT order_id
FROM order_items
WHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items
GROUP BY order_id);

D.
SELECT order_id
FROM order_items
GROUP BY order_id
HAVING SUM(unit_price*quantity) =(SELECT MAX(SUM(unit_price*quantity)) FROM order_items GROUP BY order_id);

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *