Pivot Table (From Long to Wide)

Every data scientist, scientist, and engineer should know how to create a pivot table.

𝙲𝙰𝚂𝙴 𝚆𝙷𝙴𝙽 is the best way to do so in SQL.

🚀 Here are THREE ways to pivot a table for monthly sales.
1️⃣ We find the 𝚂𝚄𝙼 of all salesperson each month. Here, use 𝚂𝚄𝙼(𝙲𝙰𝚂𝙴 𝚆𝙷𝙴𝙽).
2️⃣ We find the average sales of each salesperson each month? Use 𝙶𝚁𝙾𝚄𝙿 𝙱𝚈 + 𝙰𝚅𝙶(𝙲𝙰𝚂𝙴 𝚆𝙷𝙴𝙽)
3️⃣ Identical to example 1, but using PostgreSQL's FILTER clause.

Some other DBMS supports fancy functions for pivot table. For example, Redshift supports the PIVOT function.

Not sure what DBMS you're using? CASE WHEN works for all cases and is always your safest bet.

👇 Full example below.