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

Top Customers by Order Count | Algorithm

MediumjoinsSQL

Top Customers by Order Count

The customer relations manager wants to recognize highly active customers for a new loyalty initiative. Provide a list of all customers who have placed more than two orders, including their unique ID, name, country, and how many orders they have made.

Return

id : the customer's unique identifier name : the customer's name country : the customer's country total_orders : the number of orders placed by the customer Only include customers with more than two orders. Sort the results by total_orders in descending order, and by id in ascending order when totals are tied.

Expected output

id	name	country	total_orders
1 row — values hidden, that's the puzzle

Your query should return 1 row with these columns. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.