3 rows

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

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

Answer Posted / sree

3 rows

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger types of trigger?

1068

Is the primary key an index?

1026

how to get a list of all tables in a database? : Sql dba

977

What jobs use sql?

980

What are stuff and replace function?

1079

how to create a new view in mysql? : Sql dba

932

How do you know if a relationship is 2nf?

944

How to find 3rd highest salary of an employee from the employee table in sql?

1080

What is rank () in sql?

941

Explain how can you save or place your msg in a table?

1028

What are sql data types?

1024

What are the different set operators available in sql?

1025

Can we use pl sql in mysql?

1013

How many joins in sql?

1008

What is dense_rank?

934