anything you want as long as the values
Window functions are a group of functions that will perform calculations across a set of rows that are related to your current row. They are considered advanced sql and are often asked during data science interviews. It's also used at work a lot to solve many different types of problems. Let's summarize the 4 different types of window functions and cover the why and when you'd use them. 4 Types of Window Functions 1. Regular aggregate functions o These are aggregates like AVG, MIN/MAX, COUNT, SUM o You'll want to use these to aggregate your data and group it by another column like month or year 2. Ranking functions o ROW_NUMBER, RANK, RANK_DENSE o These are functions that help you rank your data. You can either rank your entire dataset or rank them by groups like by month or country o Extremely useful to generate ranking indexes within groups 3. Generating statistics o These are great if you need to generate simple statistics like NTILE (percentiles, quartiles, median