Prev Question
Next Question

View the Exhibit and examine the structure for the ORDERS and ORDER_ITEMS tables.

5a10494c72d59 - Which query would you execute?

You want to display ORDER_ID, PRODUCT_ID, and TOTAL (UNIT_PRICE multiplied by QUANTITY) for all the orders placed in the last seven days.

Which query would you execute?

A.
SELECT order_id, product_id, unit_price*quantity “TOTAL” FROM order_items oi JOIN orders o
ON (o.order_id=oi.order_id)
WHERE o.order_date>=SYSDATE-7;

B.
SELECT o.order_id,oi.product_id, oi.unit_price*oi.quantity ” TOTAL” FROM order_items oi JOIN orders o
USING (order_id)
WHERE o.order_date>=SYSDATE-7;

C.
SELECT o.order_id, oi.product_id, oi.unit_price*oi.quantity “TOTAL” FROM order_items oi JOIN orders o
WHERE o.order_date>=SYSDATE-7
ON (o.order_id=oi.order_id);

D.
SELECT o.order_id, oi.product_id, oi.unit_price*oi.quantity “TOTAL” FROM order_items oi JOIN orders o
ON (o.order_id=oi.order_id)
WHERE o.order_date>=SYSDATE-7;

Prev Question
Next Question

Leave a Reply

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