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
Is sqlite free?
What are the two different parts of the pl/sql packages?
Why function is used in sql?
What is meant by cursor in sql?
What is exception? What are the types of exceptions?
How many types of normalization are there?
How do you write a complex sql query?
How can I get the number of records affected by a stored procedure?
What does trigger mean in psychology?
Can procedure in package be overloaded?
Why left join is used in sql?
What is sql comments?
Which is faster union or join?
What is pivot query?
Is it important to partition hard disk?