SUM with GROUP BY
Intermediate
The sales dashboard shows revenue per region.
Write a query returning each region of sales and the sum of its amount values, named total_revenue.
Constraints
- Columns, in order:
region,total_revenue - One row per region
Hints
Hint 1
SUM(amount) adds up numbers; combine it with GROUP BY region.
Hint 2
Give the sum an alias with AS total_revenue.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.