Skip to main content
All Problems
easy0% acceptance

Total Cancelled and No-Show Visits

Operations wants to know how many visits were either cancelled or marked as no-shows. Return a single count of visits whose status is 'cancelled' or 'no_show'.

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