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

What is blob data type in oracle?

1207

What is the use of file param in imp command?

1215

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2335

How many categories of data types in oracle?

1074

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2872

How to assign values to data fields in record variables?

1077

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2297

What is concurrency in oracle?

1057

What are the advantages of oracle?

1069

Explain what are the type of synonyms?

1185

Explain do view contain data?

1052

How to initialize variables with default values?

1307

What is tns service name?

1177

What is a read write transaction in oracle?

1131

How to drop a tablespace?

1085