Skip to main content
All Problems
medium0% acceptance

Visit Count by Month and Year

Operations wants a monthly breakdown of visits. Extract the year and month from visit_date and count visits per month. Return visit_year, visit_month, and visit_count. Order by year then month.

Schema

🔑idINT
🔗patient_idINT
🔗doctor_idINT
visit_dateTEXT
diagnosisTEXT
notesTEXTNULL
follow_up_dateTEXTNULL
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute