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 / sree
3 rows
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
How to add new employee details in an employee_details table with the following details
what is rdbms? : Sql dba
How does one load ebcdic data? : aql loader
What is user defined functions?
What is cursor status?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is cte?
Is it important to partition hard disk?
What is crud diagram?
Does postgresql run on the cloud?
What are the qualities of 2nf?
What is faster join or subquery?
how is myisam table stored? : Sql dba