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

Total Spending per Customer by Country | Algorithm

MediumaggregationSQL

Total Spending per Customer by Country

A regional sales manager wants to identify high-value customers for a potential loyalty program. They need to know which customers have spent more than 1000 in total, along with their home country and total spending, to target them for special offers.

Return

full_name (the customer's full name) home_country (the customer’s country of residence) total_spent (the total amount spent by the customer) Include only customers whose total spending is greater than 1000, and list the results with the highest spenders first.

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.