Aggregate Completed Projects with Missing Metrics

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.

Output

1. One row per qualifying project.
2. Columns: project_name, project_type, metric_count, average_metric_value, positive_rate.
3. Include completed projects launched in 2025, including those without metrics.
4. Sort by positive_rate descending, then average_metric_value descending, then project_name ascending.

Output details

• Filter launch_date inclusively from DATE '2025-01-01' through exclusively before DATE '2026-01-01'.
• Count every recorded metric row in metric_count, including rows with NULL metric_value.
• Average non-NULL metric_value values for average_metric_value, defaulting to 0.00 when no average exists.
• Round average_metric_value and positive_rate to two decimal places.
• Calculate positive_rate as the percentage of metric rows with outcome equal to positive, defaulting to 0.00 when no metrics exist.