10 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 / guest

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

Answer Posted / guest

10 rows

Is This Answer Correct ?

1 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to fetch alternate records from a table? : Sql dba

1112

Explain the working of foreign key?

1067

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

Is ms sql is free?

1020

What is string join?

975

How to return multiple rows from the stored procedure?

970

What is error ora-12154: tns:could not resolve the connect identifier specified?

1077

Can I learn sql in a week?

1070

What are the two different parts of the pl/sql packages?

1087

What is the unique index?

1054

What are the different types of sql commands?

1126

Why use stored procedures?

1090

What is memory optimized table?

1043

Is keyword pl sql?

997

I need a function for a train ticket reservation please answer it thanks in advance

1024