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 / roopa
3rows'
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is a null value?
What is the difference between partitioning and sharding?
What are the types of sql commands?
What are the three forms of normalization?
What is a dirty read sql?
what are the different tables present in mysql? : Sql dba
What is a primary key sql?
How can I change database name in sql?
Can I learn sql in a week?
What is clause?
In a distributed database system, can we execute two queries simultaneously?
What are the basic techniques of indexing?
When you have to use a default "rollback to" savepoint of plvlog?
Where can I learn sql for free?
What does seeding a database mean?