3rows'

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

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

Answer Posted / roopa

3rows'

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain commit, rollback and savepoint.

933

What is dense_rank?

879

Is postgresql a server?

997

what is union, minus and interact commands? : Sql dba

1123

What is trigger in pl sql with examples?

982

How do I view tables in sql developer?

886

what are the features and advantages of object-oriented programming? : Sql dba

955

What does (+) mean in sql joins?

1013

what is row? : Sql dba

1168

How can we link a sql database to an existing android app?

983

How do I know if I have sql express or standard?

979

what is the command used to fetch first 5 characters of the string? : Sql dba

1587

Why join is faster than subquery?

1048

What is a natural join sql?

922

Is grant a ddl statement?

856