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 / sdp
4 rows
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is sql character function?
What are the triggers associated with image items?
What are the syntax and use of the coalesce function?
Explain what is rdbms?
Why use stored procedures?
What is sql mysql pl sql oracle?
What does count (*) mean in sql?
how to calculate the difference between two dates? : Sql dba
Can function return multiple values in sql?
what is unique key constraint? : Sql dba
What is the difference between a query and a report?
How to read xml file in oracle pl sql?
How to combine two stored procedures in sql?
Explain the insert into statements in sql?
How show all rows in sql?