Examine the description of the ORDER_ITEMS table: Examine this incomplete query: Which two can replace <clause> so the query completes successfully? (Choose two.)

The correct answer is B. quantity * unit_price D. total_paid. SELECT tr_sub.cur_tt, tr_sub.item, sum(tr.quantity), sum(tr.quantity*tr.unit_price) FROM (SELECT tr1.transaction_time as cur_tt, max(tr2.transaction_time) as prev_tt, tr1.item as item, IF (tr1.unit_price=tr2.unit_price, tr1.unit_price, tr2.unit_price) as t_p FROM transactions…

Reporting Aggregated Data Using the Group Functions

Question

Examine the description of the ORDER_ITEMS table:

Examine this incomplete query:

Which two can replace <clause> so the query completes successfully? (Choose two.)

Options

Aquantity, unit_price
Bquantity * unit_price
Cquantity
Dtotal_paid
Eproduct_id

How the community answered

(12 responses)

A
8% (1)
B
75% (9)
E
17% (2)

Explanation

SELECT tr_sub.cur_tt, tr_sub.item, sum(tr.quantity), sum(tr.quantity*tr.unit_price) FROM (SELECT tr1.transaction_time as cur_tt, max(tr2.transaction_time) as prev_tt, tr1.item as item, IF (tr1.unit_price=tr2.unit_price, tr1.unit_price, tr2.unit_price) as t_p FROM transactions tr1 LEFT JOIN transactions tr2 ON tr1.transaction_time>=tr2.transaction_time AND tr1.item=tr2.item GROUP BY tr1.item, tr1.transaction_time, t_p https://stackoverflow.com/questions/50771172/sql-query-get-total-value-based-on-different-unit- price-quantity-at-different-ti

Topics

#GROUP BY clause#HAVING clause#aggregate expressions#column alias

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice