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 / guest
10 rows
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is sqlerrm?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is the difference between count 1 and count (*) in a sql query?
What is sap sql anywhere?
Explain about various levels of constraint.
Can we write dml inside a function in sql server?
how to get help information from the server? : Sql dba
what are numeric data types? : Sql dba
how to present a past time in hours, minutes and seconds? : Sql dba
How bulk collect improves performance?
What is trigger and how to use it in sql?
How many commands are there in sql?
What is set serveroutput on in pl sql?
How do I order columns in sql?
What is the most common sql injection tool?