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
Define commit, rollback and savepoint?
Can a primary key be a foreign key?
What is the use of index in sql?
How do I filter in sql profiler?
What are the commands used in sql?
How to combine two stored procedures in sql?
How to add a column ‘salary’ to a table employee_details?
What is cursor in pl sql with examples?
What is %type in sql?
What are some emotional triggers?
What's the difference between a primary key and a clustered index?
What is sql comments?
What is information schema in sql?
How do I count records in sql?
Why we use stored procedure instead of query?