Skip to main content
All Problems
medium0% acceptance

Visit Status Summary with CASE

Create a summary of visits by classifying their status into broader categories. Use CASE to map: 'completed' -> 'Finished', 'cancelled' and 'no_show' -> 'Did Not Happen', 'scheduled' -> 'Upcoming'. Return status_category and visit_count. Order 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