Which of the following SQL queries correctly groups sales by product and orders the result by total sales descending?

easy📝 Syntax Q12 of 15

SQL - GROUP BY and HAVING

ASELECT product, SUM(amount) FROM sales GROUP BY product ORDER BY SUM(amount) DESC;

BSELECT product, SUM(amount) FROM sales ORDER BY product GROUP BY SUM(amount) DESC;

CSELECT product, SUM(amount) FROM sales GROUP BY product ORDER BY product DESC;

DSELECT product, SUM(amount) FROM sales ORDER BY SUM(amount) GROUP BY product DESC;

Step-by-Step Solution

Solution:

Step 1: Check GROUP BY and ORDER BY order
The correct syntax is GROUP BY first, then ORDER BY to sort grouped results.
Step 2: Verify ordering by aggregated column
Ordering by SUM(amount) DESC sorts by total sales descending, matching the requirement.
Final Answer:
SELECT product, SUM(amount) FROM sales GROUP BY product ORDER BY SUM(amount) DESC; -> Option A
Quick Check:
GROUP BY then ORDER BY with aggregate [OK]

Quick Trick: GROUP BY before ORDER BY; order by aggregate for totals [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes