Write a SQL query to track weekly project throughput and compare it against budgeted hours by team.
Use the provided teams and projects data. Include every team for each week in the project date range, including teams with no completed projects.
team_name, week_start, completed_projects, budgeted_hours, and avg_budgeted_hoursteam_name, then week_start| Column | Type | Description |
|---|---|---|
| team_idPK | INT | Unique team identifier |
| team_name | VARCHAR(100) | Team name |
| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| project_name | VARCHAR(150) | Project name |
| team_id | INT | Team responsible for the project |
| completed_at | DATE | Date the project was completed |
| budgeted_hours | DECIMAL(10,2) | Hours budgeted for the project |