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
- 10661 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
4 rows
1.vanilla
2.chocolate
3.strawberry
4.null
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How do you exit in sql?
How do I make sql search faster?
how to rename an existing table in mysql? : Sql dba
What are the qualities of 2nf?
What is bitemporal narrowing?
What type of database is cloud sql?
Determine if oracle date is on a weekend?
What is trigger point?
what is a cursor? : Sql dba
Is a view faster than a stored procedure?
What is the difference between unique and primary key constraints?
Is coalesce faster than isnull?
What is pl sql collection?
what is a control file ? : Sql dba
What is %rowtype in pl sql?
