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
Can you join a table to itself?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How to display the records between two range in Oracle SQL Plus?
How do I start pl sql?
What are triggers in sql?
How is data stored on a disk?
What are the different types of a subquery?
What are the two types of cursors in pl sql?
Why stored procedure is faster than query?
What are different functions in sql?
How many databases can sql express handle?
Can you have a foreign key without a primary key?
What packages are available to pl/sql developers?
How to run sql statements through the web interface?
What is scalar function in sql?