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

Total Spend Per Customer by Country | Algorithm

MediumaggregationSQL

Total Spend Per Customer by Country

The finance analytics team needs to identify high-value customers for targeted international campaigns. For each customer, provide their name, home country, and the total amount they have spent across all their transactions, but only include those whose total spend exceeds 1000.

Return

full_name (the customer's name) home_country (the customer's country of residence) total_spend (the sum of all transaction amounts for the customer) Include only customers whose total spend is greater than 1000, and order the results by total_spend from highest to lowest.

Expected output

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

SQLite · Ctrl+Enter to run

Run your query to see results here.