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
- 8 Answers
- 10665 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / shilpa.oracle
3 Rows.
Because group functions ignore NULL values.
flavour sum(ice_cream_sales)
vanilla 10
chocolate 27
strawberry 8
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the purpose of the sql select top clause?
How can you know that statistics should be updated?
Why do we use subquery?
Can you do multiple joins in sql?
what does the t-sql command ident_current does? : Transact sql
What company owns postgresql?
Explain the steps needed to create the scheduled job?
What are types of indexes in sql?
What are all the ddl commands?
What is the life of an sql statement?
How can we optimize a sql query?
Why use truncate instead of delete?
What is before trigger?
Which sql most popular?
Are subqueries faster than joins?
