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
12577 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 is the maximum number of triggers, you can apply on a single table?

983

What is %s in sql?

997

How can we debug in PL/SQL?

1119

What is left inner join in sql?

1023

Write the command to remove all players named sachin from the players table.

1162

Describe types of sql statements?

1046

How do I know if I have sql express or standard?

1017

List the different type of joins?

1056

what tools available for managing mysql server? : Sql dba

1063

What is sql performance tuning?

902

What is the unique index?

1044

What is the purpose of the primary key?

1050

Can you load data into multiple tables at once? : aql loader

1056

List and explain the different types of join clauses supported in ansi-standard sql?

1345

how to run 'mysql' commands from a batch file? : Sql dba

1094