[Solved] 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; | SQL

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 regions with the total sales amount per region.

BA list of all sales amounts without grouping.

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 aggregate functions
The query groups rows by 'region' and calculates the sum of 'amount' for each group.
Step 2: Analyze the output
The result shows each region once with the total sales amount summed from all rows in that region.
Final Answer:
A list of regions with the total sales amount per region. -> Option A
Quick Check:
GROUP BY + SUM() = totals per group [OK]

Quick Trick: GROUP BY with 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

More SQL Quizzes

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