Business Context

You’re working on the analytics team for a large healthcare provider network operating across 40 clinics. The network processes millions of outpatient visits per year, and care coordinators are measured on how quickly patients return for follow-up after an initial appointment (a key driver for quality metrics and reimbursement).

A common operational question is: how long does it take a patient to come back for their second visit after their first? This metric is used to identify patients who may be falling out of care, and to evaluate whether certain clinics or service lines have longer follow-up delays.

Task

Write a SQL query that returns, for each patient, the elapsed time between their first and second recorded visit.

Requirements

1. Consider only visits with a non-null visit_start_ts.
2. For each patient_id, identify the chronologically first and chronologically second visit by visit_start_ts.
3. Return one row per patient only if they have at least two visits.
4. Output the timestamps of the first and second visits, plus the elapsed time between them in hours (as a decimal).
5. Order results by patient_id ascending.

Table Definitions

patient_visits

Sample Data

patient_visits

Expected Output

Note: Patient 103 is excluded because they have only one visit in the sample data.