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 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;
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 orde_items oi JOIN orders o
ON (o.order_id=oi. order_id)
WHERE o. order date>=SYSDATE-7;