Episode 5 - Grouping and Aggregating

If we want to start building charts and summary analyses with SQL, we need to learn how to aggregate our data across different groupings. SQL opens up a world of pivoting well beyond what is possible in Excel.

If you don't have database access and want to get into this tutorial, jump back to Episode 2:
   • Episode 2 - Using HEX and Connecting to th...  

📖 Chapters:
0:00 First Examples
7:10 Practice Problem 1
10:10 Practice Problem 2
15:22 Practice Problem 3

Learn more about the data structures in use from Appendix A:
   • Appendix A - Overview of the Database Tables  

Full playlist here:
   • LEARN SQL WITH REAL MANUFACTURING SYSTEM P...…

Subscribe to our channel for more great content:
youtube.com/@LowCodeOI