Watch this video on YouTube
Which SQL feature in BigQuery would you use to transform rows into columns for a pivot table-like report?