Your question is Join Patients and Appointments. Start with the requirements and the two 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.
The University of Kansas Medical Center needs a patient appointment summary for operational reporting. Write a PostgreSQL query that joins the patient and appointment data and returns one row for every patient, including patients who have never had an appointment.
patients to appointments using the patient identifier.| Column | Type | Description |
|---|---|---|
| patient_idPK | INTEGER | Unique patient identifier |
| patient_name | VARCHAR(100) | Patient display name |
| VARCHAR(255) | Contact email when available |
| Column | Type | Description |
|---|---|---|
| appointment_idPK | INTEGER | Unique appointment identifier |
| patient_id | INTEGER | Patient associated with the appointment |
| appointment_date | DATE | Scheduled appointment date |
| status | VARCHAR(30) | Appointment status |