JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Total Spend per Customer by Country | Algorithm

MediumjoinsSQL

Total Spend per Customer by Country

The marketing team is analyzing customer spending patterns to identify top customers in different countries. They want to see the total transaction amount for each customer, grouped by the country where the transaction took place, to help target regional promotions.

Return

customer_id — unique customer identifier full_name — customer name txn_country — country where the transaction occurred total_spent — sum of amount for that customer and country Only include customers who have spent more than 1000 in a country. Order the results by total_spent descending.

Expected output

customer_id	full_name	txn_country	total_spent
4	Arjun Patel	US	6490
6	Wei Chen	MT	3150
1	Olivia Brooks	IT	2600

First 3 of 5 rows your query should return. Your column aliases don't need to match.

Ctrl+Enter to run

Run your query to see results here.