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 / sdp
4 rows
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is sql keyword?
Explain what is table in a database?
how many groups of data types? : Sql dba
What is multiple columns?
What is sql*loader and what is it used for? : aql loader
Which command is used to delete a package?
What are the packages in pl sql?
What are the advantages of stored procedure?
What is a table partition?
Is sql microsoft?
Why we use join in sql?
What is where clause in sql?
What are pl/sql packages?
Why do you partition data?
How do I partition in sql?