Repeat Customers

easy
Unit 1 · Joins & Aggregation0/3 to milestone

Marketing wants to thank customers who've ordered more than once.

Return name, order_count and total_spent for every customer with at least 2 orders, sorted by total_spent from highest to lowest.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#group-by#having#joins1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Repeat Customers · TechGradify