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.
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:
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.