[Solved] Given the table sales with columns region and amount, what is the result of this query?SELECT region, SUM(amount) FROM sales GROUP BY region; | SQL

SQL - GROUP BY and HAVING

Given the table sales with columns region and amount, what is the result 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 average sales amount.

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

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

Step-by-Step Solution

Solution:

Step 1: Understand the query components
The query groups rows by region and calculates the sum of amount for each group.
Step 2: Determine the output
The output will show each region once with the total sales amount summed up.
Final Answer:
A list of regions with the total sales amount for each region. -> Option D
Quick Check:
GROUP BY region + SUM(amount) = total per region [OK]

Quick Trick: SUM with GROUP BY gives total per group, not average or error [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

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