# Grouping sets and Window functions Lecture

> In this presentation, Zach explores a range of topics related to Advanced SQL Analytical Patterns. The discussion covers the application of recursive CTEs, count case when, grouping sets, cross join unnest, cube, rollup, and window functions. Drawing from Zachs experience in conducting interviews a…

- Web page: https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lecture-p735-l580
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 7: Analytical Patterns & CDC
- Access: Requires enrollment in AnalyticsExpert
- Length: 30 min video
- Skills: SQL
- Academy: DataExpert.io Academy

## About this lesson

In this presentation, Zach explores a range of topics related to Advanced SQL Analytical Patterns. The discussion covers the application of recursive CTEs, count case when, grouping sets, cross join unnest, cube, rollup, and window functions. Drawing from Zachs experience in conducting interviews and working with these concepts, the presentation offers insights and practical advice.

## Navigation

- Previous lesson: [Growth Accounting Models Lab](https://www.dataexpert.io/lesson/growth-accounting-models-lab-p735-l582.md)
- Next lesson: [Grouping sets and Window functions Lab](https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lab-p735-l581.md)