Skip to main content
All Problems
hard0% acceptance

Days Until Next Visit per Patient

For each patient's visits, compute the number of days until their next visit using LEAD(). Return patient_id, visit_date, next_visit_date, and days_until_next. Order by patient_id, visit_date.

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