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
12588 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 nvarchar in sql?

917

How to rename a table?

1001

what are the advantages of using stored procedures? : Sql dba

1094

Can we connect to postgresql using sql developer?

985

what is foreign key? : Sql dba

1002

define join and explain different type of joins? : Sql dba

935

How many types of triggers are there in pl sql?

1052

What is sql profiler in oracle?

1072

What is the difference between microsoft access and sql?

1006

What are the two parts of design view?

1007

What is the difference between the sql*loader and import utilities? : aql loader

1013

What are the main features of cursor?

1067

Can dml statements be used in pl/sql?

1062

what is the difference between sql and t-sql? : Transact sql

1074

What is a primary key? Explain

960