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
12332 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 java sql drivermanager?

1023

List the different type of joins?

1004

How to return multiple rows from the stored procedure?

916

Why are cursors used?

1059

Define a temp table?

967

What is a primary key? Explain

922

How do you update a sql procedure?

974

Is pl sql and postgresql same?

1058

How does cross join work in sql?

959

Is sqlite free?

908

What is sql stand for?

947

What does desc stand for?

1022

How is a PL/SQL code compiled?

1172

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

947

Why commit is not used in triggers?

994