Your question is Diagnose Missing Credit Metrics in Reports. 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.
You are given a client report built from Moody's credit data that is returning NULL for specific credit metrics. Write a PostgreSQL query that identifies which report rows are missing metric values, shows the related entity and metric name, and flags whether the null came from the source metric table or from a failed match to the metric reference table.
| Column | Type | Description |
|---|---|---|
| report_idPK | INT | Primary key for the report row |
| entity_id | INT | Entity being reported on |
| metric_code | VARCHAR(20) | Metric requested in the report |
| report_date | DATE | Report date |
| metric_value | NUMERIC(12,4) | Final metric value shown in the report |
| Column | Type | Description |
|---|---|---|
| entity_id | INT | Entity identifier |
| metric_code | VARCHAR(20) | Metric code in the source system |
| metric_value | NUMERIC(12,4) | Source metric value |
| as_of_date | DATE | Date the metric was captured |
| Column | Type | Description |
|---|---|---|
| metric_codePK | VARCHAR(20) | Metric code key |
| metric_name | VARCHAR(100) | Human-readable metric name |
| is_active | BOOLEAN | Whether the metric is currently valid |