Write a SQL query to analyze operational performance by city and week, joining trip data with service status data to calculate completion rate, average delay, and week-over-week change. Use all trips as the operational population, including trips without a matching service status. Treat week-over-week change as the difference in completion rate from the previous available week for the same city.
Output
- One row per city and calendar week, with
city, week_start, completion_rate, average_delay_minutes, and completion_rate_wow_change.
- Include cities and weeks represented in trip data, ordered by
city and week_start.
