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
12677 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

how to get a list of all tables in a database? : Sql dba

978

Why commit is not used in triggers?

1042

Is sql better than access?

1021

Explain mutating table error.

1208

What are primary key and foreign key and how they work?

978

Are stored procedures compiled?

932

explain advantages of innodb over myisam. : Sql dba

1130

What is materialized view. What are different methods of refresh?

1393

Differentiate between sga and pga.

1167

What are the two virtual tables available at the time of database trigger execution?

1223

What is relationship? How many types of relationship are there?

1185

What are the two types of periodical indexes?

940

How much does sqlite cost?

1044

How do I find duplicates in the same column?

1089

Is postgresql a server?

1055