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 rename a column in an existing table?

1013

What is a read write transaction in oracle?

1063

Why is oracle so popular?

970

master table and child table performances and comparisons in Oracle ?

2112

What is oracle join syntax?

982

Can the query output be sorted by multiple columns in oracle?

967

what is the difference between data migration and production migration.

2326

What do you understand by a database object?

1038

How to create a new user account in oracle?

991

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1997

Can you have more than one content canvas view attached with a window ?

2311

What would you do with an in-doubt distributed transaction?

1957

What is the order of defining local variables and sub procedures/functions?

1041

How to assign values to variables?

1077

How to export data to a csv file?

1271