Which query would you execute?

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?

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 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 ON (o.order_id=oi. 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 USING (order_id) WHERE o.order_date>=SYSDATE-7;



Leave a Reply 0

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