5 Rows

SELECT category, type, AVG(price)
FROM products GROUP BY category, type ORDER BY 1, 2

If there are three distinct categories in the "products"
table, and each one has five different types, how many rows
are returned by the query above?

1. 1 row
2. 3 rows
3. 5 rows
4. 8 rows
5. 15 rows

Question Posted / hemanth

3 Answers
6999 Views
I also Faced
E-Mail Answers

Answer Posted / hemanth

5 Rows

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by field in sql?

1077

What is an example of translating a date into julian format?

1117

How do you change a value in sql?

1019

What are the operators used in select statements?

1058

How to assign sql query results to pl sql variables?

1078

how to get a list of columns in an existing table? : Sql dba

965

what is column? : Sql dba

1002

what is the use of friend function? : Sql dba

1023

What is file based approach?

941

What is the meaning of disabling a trigger?

1182

What is the advantage of index in sql?

970

How you improve the performance of sql*loader? : aql loader

1013

Explain what is dbms?

1060

Is pl sql still used?

975

What is query syntax?

967