four rows will be returned displaying null as the last row

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

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

Answer Posted / tulsi

four rows will be returned displaying null as the last row

Is This Answer Correct ?

13 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does pl sql work?

952

Explain the uses of control file.

1028

What is the difference between a subquery and a join?

1079

What has stored procedures in sql?

1051

How to process query result in pl/sql?

1109

Which command is used to delete a package?

1150

how to write date and time literals? : Sql dba

948

Is left join same as inner join?

1096

what is a database? : Sql dba

1148

what are all types of user defined functions? : Sql dba

1033

What is the starting oracle error number? What is meant by forward declaration in functions?

978

How many sql commands are there?

1102

Why do we go for stored procedures?

1038

What is having clause in sql?

950

What is record data type?

901