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 |