View the Exhibit and examine the structure of the ORDER_ITEMS table.
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?
ORDER ITEMS
A. SELECT order_id FROM order_itemsWHERE(unit_price*quantity) = MAX(unit_price*quantity) GROUP BY order_id;
B. SELECT order_id FROM order_itemsWHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items) GROUP BY order_id;
C. SELECT order_id FROM order_itemsWHERE (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_idHAVING SUM(unit_price*quantity) =(SELECT MAX(SUM(unit_price*quantity)j FROM order_items GROUP BY order_id);
|
Download Printable PDF. VALID exam to help you PASS. |
 |