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
Why truncate is faster than delete?
Mention what does the hierarchical profiler does?
how to escape special characters in sql statements? : Sql dba
Why function is used in sql?
what is oltp (online transaction processing)? : Sql dba
What does stand for in sql?
How to run sql commands in sql*plus?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is auto increment?
Why functions are used in sql?
Explain the components of sql?
Is it possible to create startup or shutdown trigger for on-schema?
Which sql most popular?
What are functions in sql?
What jobs use sql?