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
Answer Posted / vijay
15 rows
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Why do we need cursors in pl sql?
Why functions are used in sql?
What is rowid in sql?
How do I run sql profiler?
What is group by in sql?
How do I edit a stored procedure?
what is the difference difference between procedure and packages
What are the topics in pl sql?
What is sql and db2?
What is materialized view in sql?
Why should I use postgresql?
How do I filter in sql profiler?
what is a unique key ? : Sql dba
Is sql harder than python?