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

Total Spending Per Customer in Home Country | Algorithm

MediumaggregationSQL

Total Spending Per Customer in Home Country

The finance analytics team wants to understand domestic spending patterns among customers. They need to see, for every customer who has spent money in their home country, the customer’s name, their home country, and the total amount they have spent there.

Return

full_name (the customer’s name) home_country (the customer’s home country) total_home_country_spent (the total spent by the customer in their home country) Include only customers who have made at least one transaction in their home country, and order the results by total_home_country_spent from highest to lowest.

Expected output

First 3 of 7 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.