Skip to main content
All Problems
easy0% acceptance

Customer Count by State

The expansion team wants to see customer distribution across states. Return each state and the number of customers in that state, but only include states that have at least 2 customers. Sort by customer 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