Skip to main content
All Problems
easy0% acceptance

Visit Count by Day of Week

Scheduling wants to understand visit distribution across the week. Return the day of the week (0=Sunday through 6=Saturday) and the number of visits on that day, sorted by visit count descending.

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