Write a SQL query to track weekly implementation progress, joining client, project, and usage tables to calculate completion rate and identify at-risk accounts for Commure.
Use active projects and implementation usage from the reporting weeks beginning January 6, January 13, and January 20, 2025. An account is at risk when cumulative completion is below 80% of the expected completion pace.
Output
- One row per active project and reporting week.
- Columns:
client_name, project_name, week_start, weekly_units, cumulative_units, completion_rate, and risk_status.
- Include projects with no usage, show rates as percentages, and order by client name, project name, and week start.
