It would return 4 rows because there is also a sum of ice_cream

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

Question Posted / kapil

8 Answers
12335 Views
Sonata, I also Faced
E-Mail Answers

Answer Posted / kapil

It would return 4 rows

because there is also a sum of ice_cream_sales for null also

so it would return 4 rows including null with order
dependimg on the value of sum function returned .

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are functions in sql?

906

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1040

Define concurrency control. : Transact sql

1106

What is Collation Sensitivity ? What are the various type ?

906

What is sql profiler in oracle?

1015

Why do we need cursor in pl sql?

1080

How does a trigger work?

990

What are the triggers associated with image items?

1000

What is snowflake sql?

1013

How to install oracle sql developer?

986

What is aggregate function in sql?

988

describe transaction-safe table types in mysql : sql dba

946

What is data type in sql?

923

how to do backup entire database? : Transact sql

1070

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1062