select ORDER_NO,AVG(ITEM_COST) from <TN> Group by ORDER

24. Display the order number for all orders whose average
item cost is greater than the overall average item cost
across all orders.

Question Posted / sarath

Answer Posted / sarath

select ORDER_NO,AVG(ITEM_COST) from <TN>
Group by ORDER_NO
having AVG(ITEM_COST) > (Select Max(AVG(ITEM_COST)) from
<TN> Group by ORDER_NO)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to write a left outer join with the where clause in oracle?

1086

How to retrieve values from data fields in record variables?

1120

Explain user account with reference to oracle.

993

Explain oracle left join with an example?

1018

What is a system tablespace?

1083

What is the recommended interval at which to run statspack snapshots, and why?

2921

What are the numeric comparison operations?

1120

How to write date and time interval literals in oracle?

1036

How to set up autotrace for a user account?

1059

What is Redo Log Buffer in Oracle?

1210

How to export several tables together?

1049

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

How to store pictures on to the database?

979

How do I manually create a database in oracle?

1023

What is max rowid in oracle?

1025