My output: select OrderID, price from ORDER_ITEM where price > (select avg(price

Question

My output:

select OrderID, price
from ORDER_ITEM
where price > (select avg(price) from ORDER_ITEM)
order by price desc

    OrderID                                   price
----------- ---------------------------------------
       2001                                  175.50
       1035                                  145.00
       3022                                  145.00
       2002                                  125.00
       1033                                  100.00
       1032                                   85.00
       1031                                   82.50
       1019                                   80.00
       1038                                   57.50
       1016                                   47.95
       1018                                   47.50
       3021                                   35.00
       1004                                   32.50
       1020                                   30.00

(14 rows affected)

Now I need to get another column, from a different linking table.

How would I add another subquery for this?

Explanation / Answer

Please enter require COLUMNNAME and table name

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.