select order_no,avg(cost) from order group by order

17. Display the order number and average item cost for each
order.

Question Posted / yogesh sharma

Answer Posted / yogesh sharma

select order_no,avg(cost) from order group by order_no;

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to see free space of each tablespace?

1081

How to use like conditions in oracle?

1115

What is blob datatype?

1197

Explain about achiever in sql?

1086

What are transaction isolation levels supported by oracle?

1116

How to drop a stored function?

1182

Can you drop an index associated with a unique or primary key constraint?

1069

How to rename a tablespace in oracle?

1126

What is data file?

1150

How to initialize variables with default values?

1307

How to assign a table row to a record variable?

1091

What is BBED in Oracle?

1197

State any two functions of oracle?

1096

Can we use bind variables in oracle stored procedure?

987

Explain what are synonyms used for?

1094