SELECT flavor, SUM (ice_cream_sales) FROM sales_detail
GROUP BY flavor ORDER BY 2 DESC
If the "sales_detail" table contains ten records with
different values in the flavor column (two "vanilla,"
three "chocolate," four "strawberry," and one NULL), how
many rows are returned by the sample code above?
1. 0 rows
2. 1 row
3. 3 rows
4. 4 rows
5. 10 rows
Answer Posted / sree
3 rows
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a record in pl/sql?
How do you modify a column in sql?
What is server name sql?
What are joins in sql?
What is the use of sqlerrd 3?
Why primary key is required?
What is number function in sql?
How to select 10 records from a table?
What is a unique key?
Can we use having without group by in sql?
Explain exception handling in pl/sql?
How many joins in sql?
how many triggers are allowed in mysql table? : Sql dba
how to rename an existing column in a table? : Sql dba
what is the use of double ampersand (&&) in sql queries?