Given the table sales with columns region and amount, what will this query return?

medium📝 query result Q13 of 15

SQL - GROUP BY and HAVING

Given the table sales with columns region and amount, what will this query return?

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

ASyntax error due to missing WHERE clause

BList of all sales amounts without grouping

CSum of all sales amounts without region breakdown

DTotal sales amount for each region

Step-by-Step Solution

Solution:

Step 1: Understand the query components
The query groups rows by region and sums amount per group.
Step 2: Predict the output
It returns one row per region with the total sales amount for that region.
Final Answer:
Total sales amount for each region -> Option D
Quick Check:
GROUP BY region + SUM(amount) = total per region [OK]

Quick Trick: GROUP BY + SUM = 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