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
- 10662 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / guest
10 rows
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What are hotfixes and patches?
Does pdo prevent sql injection?
What does stand for in sql?
What is duration in sql profiler trace?
explain primary keys and auto increment fields in mysql : sql dba
What is identity column in sql server?
What does the base_object_type column shows in the user.triggers data dictionary view?
Why we use triggers in mysql?
Does varchar need length?
What is cursor status?
What is sql dialect?
What is compound trigger?
Explian rowid, rownum? What are the psoducolumns we have?
what is a primary key? : Sql dba
Why should I use postgresql?
