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
- 10664 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / kapil
It would return 4 rows
because there is also a sum of ice_cream_sales for null also
so it would return 4 rows including null with order
dependimg on the value of sum function returned .
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how to increment dates by 1 in mysql? : Sql dba
Is sqlite good enough for production?
what is log shipping? : Sql dba
Why use stored procedures?
What is constant in pl sql?
What is a pragma statement?
What is snowflake sql?
What is cursor in pl sql?
How do you declare a constant?
What is normalisation in sql?
What is transaction control language (tcl)?
How do you create a db file?
What is the starting oracle error number?
How do you know if a relationship is 2nf?
What is cte sql?
