Part I: Common Table Expressions
1. Basics of Common Table Expressions
2. Non-Recursive Common Table Expressions
3. Recursive Common Table Expressions
Part II: Window Functions
4. Basics of Window Functions
5. Recognizing Opportunities for Window Functions
6. Window Functions in Practice
7. Combining Window Functions and CTEs.