Context

Operations teams often want a report with one row per week and separate columns for each region. This is a common pivot-style summary used for dashboards and weekly reviews.

Question

Explain how you would use SQL to create a pivot-style table that summarizes operational performance by region and week in PostgreSQL. Your answer should cover:

1. How to group records into weekly buckets
2. How to aggregate operational metrics such as total jobs or average completion time
3. How to turn region values into columns in the final result
4. What to do when some regions have no data for a given week

Scope Guidance

Keep the explanation practical. The interviewer expects you to describe the SQL approach clearly, mention PostgreSQL-friendly techniques, and explain trade-offs between manual pivoting and database-specific pivot tools.