# TA Office Hour 3

> Office hours provide an opportunity for students to ask questions and clarify doubts regarding their assignments. This session focused on the current week's SQL assignment in Snowflake, specifically using common table expressions (CTEs) and user-defined functions (UDFs) to analyze an actor films da…

- Web page: https://www.dataexpert.io/lesson/ta-office-hour-3-april2025
- Program: [Analytics Engineering Boot Camp starting April 14th, 2025](https://www.dataexpert.io/program/analytics-engineering-boot-camp-april-2025-5702)
- Access: Requires enrollment in Analytics Engineering Boot Camp starting April 14th, 2025
- Length: 48 min video
- Skills: SQL, Python, Snowflake
- Academy: DataExpert.io Academy

## About this lesson

Office hours provide an opportunity for students to ask questions and clarify doubts regarding their assignments. This session focused on the current week's SQL assignment in Snowflake, specifically using common table expressions (CTEs) and user-defined functions (UDFs) to analyze an actor films dataset. Key topics included generating sequences of years to identify inactive periods for actors and leveraging Python for UDFs, along with discussions on project proposals and homework assistance.

## Navigation

- Previous lesson: [TA Office Hour 2](https://www.dataexpert.io/lesson/ta-office-hour-2-april2025.md)
- Next lesson: [TA Office Hour 4 ](https://www.dataexpert.io/lesson/ta-office-hour-4-april2025.md)