Write a SQL query to retrieve specific performance metrics from a relational database. Use the metric_catalog and performance_measurements tables to retrieve active metric codes M001, M002, and M003 for the first quarter of 2025. Include metrics without a recorded measurement and classify each result based on its target value.
metric_code, metric_name, measured_on, metric_value, and performance_status.| Column | Type | Description |
|---|---|---|
| metric_codePK | VARCHAR(10) | Unique performance metric code |
| metric_name | VARCHAR(100) | Display name of the metric |
| target_value | NUMERIC(10,2) | Target value used for classification |
| is_active | BOOLEAN | Whether the metric definition is active |
| Column | Type | Description |
|---|---|---|
| measurement_idPK | INT | Unique measurement identifier |
| metric_code | VARCHAR(10) | Referenced metric code |
| measured_on | DATE | Date on which the metric was measured |
| metric_value | NUMERIC(10,2) | Recorded metric value |
| source_system | VARCHAR(50) | System that supplied the measurement |