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
- 8 Answers
- 10663 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / tulsi
four rows will be returned displaying null as the last row
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is the current version of postgresql?
What is nvarchar in sql?
How does left join work in sql?
How to run pl sql program in mysql?
Is ms sql is free?
Mention what pl/sql package consists of?
How do I create a sql script?
What is blind sql injection?
What is a sql*loader control file?
What is bind variable in pl sql?
What does select top 1 do in sql?
Is sql open source?
What is clause in sql?
Why function is used in sql?
What is sql partition?
