View the Exhibit and examine the structure for the ORDERS and ORDER_ITEMS tables.
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 o.order_id, oi.product_id, oi.unit_price*oi.quantity “TOTAL” FROM orde_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 WHERE o.order_date>=SYSDATE-7 ON (o.order_id=oi. order_id);
C.
SELECT orde_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;
D.
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;