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 / guest
10 rows
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
how to decrement dates by 1 in mysql? : Sql dba
Explain what is a column in a table?
What is the difference between local variables and global variables?
Why join is faster than subquery?
what are the drivers in mysql? : Sql dba
What is a primary key? Explain
What is the function that is used to transfer a pl/sql table log to a database table?
How many types of cursors are available in pl/sql?
What sql does db2 use?
what are the advantages of sql ? : Sql dba
Is pl sql useful?
Which sorts rows in sql?
What is a record in a database?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is trigger price?