# Office Hour 4

> Office Hour 4 focuses on discussing homework assignments related to querying NBA player data. Participants learn how to track state changes of players across seasons using the bootcamp NBA players table, as well as alternative approaches using the NBA player seasons table for better historical insi…

- Web page: https://www.dataexpert.io/lesson/office-hour-4
- Program: [Analytics Engineering Boot Camp starting October 2024](https://www.dataexpert.io/program/analytics-engineering-boot-camp)
- Module: TA Office Hours
- Access: Requires enrollment in Analytics Engineering Boot Camp starting October 2024
- Length: 47 min video
- Skills: SQL
- Academy: DataExpert.io Academy

## About this lesson

Office Hour 4 focuses on discussing homework assignments related to querying NBA player data. Participants learn how to track state changes of players across seasons using the bootcamp NBA players table, as well as alternative approaches using the NBA player seasons table for better historical insights. The session also covers aggregation techniques with grouping sets to analyze player performance metrics, including total points scored by players for specific teams and seasons.

## Navigation

- Previous lesson: [Office Hour 3](https://www.dataexpert.io/lesson/office-hour-3.md)