Which three statements are true regarding the output of this SQL statement?

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

Evaluate the following SQL statement:
SELECT o.customer_id, oi.product_id, SUM(oi.unit_price*oi. quantity) “Order Amount”
FROM order_items oi JOIN orders o
ON oi.order_id = o.order_id
GROUP BY CUBE (o.customer_id, oi.product_id);
Which three statements are true regarding the output of this SQL statement? (Choose three.)

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

Evaluate the following SQL statement:
SELECT o.customer_id, oi.product_id, SUM(oi.unit_price*oi. quantity) “Order Amount”
FROM order_items oi JOIN orders o
ON oi.order_id = o.order_id
GROUP BY CUBE (o.customer_id, oi.product_id);
Which three statements are true regarding the output of this SQL statement? (Choose three.)

A.
t would return the subtotals for the Order Amount of every CUSTOMER_ID.

B.
t would return the subtotals for the Order Amount for every PRODUCT_ID.

C.
t would return the subtotals for the Order Amount of every PRODUCT_ID and CUSTOMER_ID
as one group.

D.
t would return the subtotals for the Order Amount of every CUSTOMER_ID and PRODUCT_ID
as one group.

E.
t would return only the grand total for the Order Amount of every CUSTOMER_ID and
PRODUCT_ID as one group.



Leave a Reply 1

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


Marian

Marian

A, B and E. C and D are equivalent and make no sense.