📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
Creating a pivot table in Excel is easy. It's also possible to create a pivot table in MySQL.
In this video, I'll explain what a pivot table is and show you step-by-step how to create a pivot table in MySQL.
⏱ TIMESTAMPS:
00:00 - Our data
00:40 - Add the first year
04:17 - Add all years
05:11 - COUNT or SUM?
🔗 VIDEO LINKS:
SQL scripts from this video: https://github.com/bbrumm/databasesta...