Your question is Join Two Tables in SQL. Start with the requirements and the one table 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.
Komodo Health analytics workflows need a quick view of recent completed clinical events. Write a PostgreSQL query that retrieves qualifying events from the clinical_events table.
status = 'completed' and an event_date on or after January 1, 2025.event_id, patient_id, event_date, and event_type, ordered from most recent to oldest event. Use event_id as a tie-breaker for identical dates.| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique clinical event identifier |
| patient_id | VARCHAR(20) | De-identified patient identifier |
| event_date | DATE | Date of the clinical event |
| event_type | VARCHAR(40) | Type of clinical event |
| status | VARCHAR(20) | Event processing status |