Write a SQL query to analyze operational performance by location, including daily volume, average processing time, and week-over-week change.
Use completed processing jobs with valid start and completion timestamps. Exclude cancelled or incomplete jobs. Week-over-week change should compare each location's completed-job volume for the current calendar week with the previous calendar week.
Output
- One row per location and date with completed jobs
- Columns:
location_name, work_date, daily_volume, avg_processing_minutes, and week_over_week_change_pct
- Include the current and previous weekly volumes only through the calculated percentage, return NULL when no prior-week volume exists, and order by location name then date
