Describe how you would solve a business case scenario using a past project as an example. Use the supplied project and project metric data to demonstrate how you would summarize outcomes for completed projects launched in 2025. Include projects without recorded metrics and explain how the result could support a business recommendation.
project_name, project_type, metric_count, average_metric_value, positive_rate.positive_rate descending, then average_metric_value descending, then project_name ascending.| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| project_name | VARCHAR(100) | Project name |
| project_type | VARCHAR(50) | Project category |
| status | VARCHAR(30) | Current project status |
| launch_date | DATE | Project launch date |
| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Unique metric record identifier |
| project_id | INT | Referenced project |
| metric_value | DECIMAL(10,2) | Observed metric value |
| outcome | VARCHAR(20) | Outcome classification |