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 / roopa
3rows'
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are the advantages of stored procedure?
Why we use stored procedure instead of query?
What are the types of triggers in sql?
What is sql and how does it work?
Is sqlite free?
How would you reference column values before and after you have inserted and deleted triggers?
Does pdo prevent sql injection?
what is the use of friend function? : Sql dba
Define concurrency control. : Transact sql
How do I delete a trigger?
How do I view an execution plan in sql?
How many triggers can be applied on a table?
What are the key differences between SQL and PL SQL?
what's the difference between a primary key and a unique key? : Sql dba
Does varchar need length?