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 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;



Leave a Reply 1

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