Pivot Patterns and Data Reshaping

The "Pivoting and Unpivoting Data" chapter covered the mechanics: CASE inside an aggregate, the PIVOT operator, CROSSTAB, and unpivoting with UNION ALL or LATERAL.

This chapter focuses on recognizing pivot problems when they appear in interviews, handling the more complex variations that interviewers use to separate candidates, and combining pivots with window functions and multi-aggregate reporting.