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

what is the difference difference between procedure and packages

10414

What is sql exception?

976

What are types of exception?

922

Why is a trigger used?

945

What are the key differences between SQL and PL SQL?

1217

What is pragma in pl sql?

1116

What is #table in sql?

1106

Can we call procedure in select statement?

1059

What is embedded sql with example?

1056

Is nosql relational?

947

How do you write a complex sql query?

1088

Which is better cte or subquery?

1030

how to dump a table to a file with 'mysqldump'? : Sql dba

1038

What is cursor and why it is required?

1183

How long does it take to learn pl sql?

1064