4 rows 1.vanilla 2.chocolate 3.strawberry 4.null

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 / gvmahesh

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

Answer Posted / gvmahesh

4 rows

1.vanilla
2.chocolate
3.strawberry
4.null

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How long will it take to learn pl sql?

981

Is hadoop a nosql?

1054

What is exception? What are the types of exceptions?

1115

What is difference between inner join and cross join?

1019

what is index? : Sql dba

1045

What are the events on which a database trigger can be based?

1246

How to place comments in pl/sql?

1218

What are the advantages of indexing?

1030

how are mysql timestamps seen to a user? : Sql dba

1198

How many sectors are in a partition?

1119

What is the basic form of sql query?

996

Explain the working of primary key?

1155

What is sql performance tuning?

982

What is time based sql injection?

1035

What are the main features of cursor?

1109