It would return 4 rows because there is also a sum of ice_cream

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

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

Answer Posted / kapil

It would return 4 rows

because there is also a sum of ice_cream_sales for null also

so it would return 4 rows including null with order
dependimg on the value of sum function returned .

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

1045

Why is sql better than hql?

1065

What is difference between pl and sql?

1111

What is difference between stored procedure and trigger?

1252

How do you explain an index?

1334

How do you write a complex sql query?

1142

Explain the components of sql?

1108

How to connect a sql*plus session to an oracle server?

1176

what are date and time intervals? : Sql dba

1105

what are the performance and scalability characteristics of mysql? : Sql dba

1034

What is exit statement?

1063

What is the use of & in pl sql?

1097

What are the advantages of pl sql over sql?

1077

How many subqueries can be nested in a statement?

1042

What is a behavioral trigger?

1025