4 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 / sdp

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

Answer Posted / sdp

4 rows

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of views in sql?

1041

Can we use joins in subquery?

1089

What is the process of debugging?

1006

Does sql full backup truncate logs?

968

What is java sql package?

1026

how to create a test table in your mysql server? : Sql dba

946

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

What is the main difference between sql and pl/sql?

1028

what is the bond code in materialized view?

2933

explain advantages of myisam over innodb? : Sql dba

1017

What is transaction control language (tcl)?

1073

Why triggers are used?

939

How do I run a program in pl sql?

952

What is cartesian join in sql?

1030

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1076