Your question is Top Diagnosis Codes. 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.
Providence's clinical data warehouse contains diagnosis records associated with patient encounters. Write a PostgreSQL query to identify the most frequently recorded diagnosis codes.
diagnosis_code.| Column | Type | Description |
|---|---|---|
| diagnosis_idPK | INT | Unique diagnosis record identifier |
| encounter_id | INT | Providence encounter identifier |
| diagnosis_code | VARCHAR(10) | ICD diagnosis code |
| recorded_date | DATE | Date the diagnosis was recorded |