Skip to main content
All Problems
easy0% acceptance

Count Patients by State

Management wants to know where the patients are located. Count the number of patients in each state, ordered from the most patients to the fewest.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
date_of_birthTEXT
genderTEXT
emailTEXT
phoneTEXTNULL
blood_typeTEXT
cityTEXT
stateTEXT
🔗insurance_idINTNULL
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute