Given the table sales with columns region and amount, what is the output of this query?

medium📝 query result Q13 of 15

SQL - GROUP BY and HAVING

Given the table sales with columns region and amount, what is the output of this query?

SELECT region, SUM(amount) FROM sales GROUP BY region;

AA list of all sales amounts without grouping.

BA list of regions with the total sales amount for each region.

CAn error because SUM() cannot be used with GROUP BY.

DA list of regions sorted by amount.

Step-by-Step Solution

Solution:

Step 1: Understand GROUP BY with SUM()
The query groups rows by region and sums the amount for each group.
Step 2: Predict output format
The output shows each region once with the total amount of sales in that region.
Final Answer:
A list of regions with the total sales amount for each region. -> Option B
Quick Check:
GROUP BY + SUM() = grouped sums [OK]

Quick Trick: GROUP BY + SUM() gives totals per group [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