Write a SQL query to analyze staffing performance by client and week at Adecco General Staffing, including fills, open requisitions, and fill rate trends over time.
Use the reporting period from January 1 through February 4, 2024. Include clients with requisitions during the period and calculate fill rate as fills divided by fills plus open requisitions.
Output
- One row per client and Monday-starting week, including weeks with no activity.
- Columns:
client_name, week_start, fills, open_requisitions, fill_rate, prior_week_fill_rate, and fill_rate_change.
- Include zero counts, use NULL when the fill-rate denominator is zero, and order by client name and week.
