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
12912 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

What is the use of <> sql?

1040

What is trigger in sql?

1156

Can pl sql procedure have a return statement?

1072

What is posting?

1086

What is the largest value that can be stored in a byte data field?

1060

Should I use mbr or gpt?

1063

What is composite primary key in sql?

1043

How do I create a sql database?

1057

What is oracle and pl sql?

1161

How do I filter in sql profiler?

1055

What is the difference between pl and sql?

1153

How does a covering index work?

1013

What is range partitioning?

1017

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1080

tell me about various levels of constraint. : Sql dba

1083