We use PIVOT queries when we need to transform data from row-level to columnar data. We will introduce the basic knowledge of SQL Server Pivot, then answers two T-SQL practice questions related to PIVOT.