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
- 10658 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / sdp
4 rows
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the benefits of pl/sql packages?
What is partition by in sql?
Can we join tables without foreign key?
How do you determine the current isolation level? : Transact sql
Which version of sql do I have?
Which data type is a composite type?
Can we delete column in sql?
How do you add a column to a table?
What do you know by pl/sql cursors?
What is the difference between microsoft access and sql server?
What is sql key?
how mysql optimizes distinct? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
What is an alias command?
how to create a new table in mysql? : Sql dba
