Skip to main content
All Problems
easy0% acceptance

Customers with Multiple Orders

Identify repeat buyers. Find customers who have placed more than one order. Return their customer id, first name, last name, and order count, sorted by order count descending.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
emailTEXT
phoneTEXTNULL
cityTEXT
stateTEXT
countryTEXT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute