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.