5. Window Functions for Data Analysis
By the end of this chapter, you will be able to:
- Explain what a window function is
- Write basic window functions
- Use common window functions to calculate statistics
- Analyze sales data using window functions and a window frame
In this chapter, we will cover window functions, functions similar to an aggregate function but that allow a new range of capabilities and insights.