Your question is SQL Joins Across Tables. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Health Catalyst's Population Health workflows need a patient-level list of active patients with currently open care gaps. Write a PostgreSQL query that joins patient, care gap, and outreach action data.
high-touch; classify all others as standard.| Column | Type | Description |
|---|---|---|
| patient_idPK | INT | Unique patient identifier |
| patient_name | VARCHAR(100) | Patient display name |
| region | VARCHAR(50) | Care delivery region |
| is_active | BOOLEAN | Whether the patient is actively enrolled |
| enrollment_date | DATE | Date the patient entered the program |
| Column | Type | Description |
|---|---|---|
| gap_idPK | INT | Unique care gap identifier |
| patient_id | INT | Patient associated with the gap |
| gap_type | VARCHAR(50) | Clinical or preventive care gap type |
| status | VARCHAR(20) | Current gap status |
| due_date | DATE | Date by which the gap should be addressed |
| priority | VARCHAR(20) | Operational priority |
| Column | Type | Description |
|---|---|---|
| action_idPK | INT | Unique outreach action identifier |
| gap_id | INT | Care gap targeted by the action |
| action_status | VARCHAR(20) | Status of the outreach action |
| action_date | DATE | Date the action occurred |
| action_note | VARCHAR(200) | Brief operational note |