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
- One row per qualifying project.
- Columns:
project_name, project_type, metric_count, average_metric_value, positive_rate.
- Include completed projects launched in 2025, including those without metrics.
- 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.
