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
What are the various levels of constraints?
What is the most restrictive isolation level? : Transact sql
What does := mean in pl sql?
What is the difference between function and procedure in pl/sql?
what are ddl statements in mysql? : Sql dba
Why triggers are used?
What is db journal file?
What is a ddl command?
Explain the components of sql?
How to select random rows from a table?
What is pivot table in sql?
What is the difference between null value, zero, and blank space?
Are views faster than queries?
What is a table in a database?
how to get a list of columns in an existing table? : Sql dba