Analyze a given dataset and interpret the results.
Use the supplied categories and observations to evaluate valid records from 2025. Include categories with no qualifying observations, account for missing metric values, and classify each category relative to the overall average of category averages.
category_name, qualifying_observations, average_value, dataset_average, and interpretation.| Column | Type | Description |
|---|---|---|
| category_idPK | INT | Unique category identifier |
| category_name | VARCHAR(100) | Category label |
| Column | Type | Description |
|---|---|---|
| observation_idPK | INT | Unique observation identifier |
| category_id | INT | Referenced category |
| observed_at | DATE | Observation date |
| metric_value | DECIMAL(12,2) | Measured value, which may be missing |
| status | VARCHAR(20) | Observation validation status |