Window Functions
Intro to Window Functions
Using Window Function for Aggregate Functions
Running Total Salary by Job Title
Earliest Join Date for Each Job Title
Using the Frame Clause
Frame Clause in SQL
Maximum Spend Within Each User Region
Number of Orders and Cumulative Sum
Average Order Amount Window
Using ROW_NUMBER
Top Product by Department
First Order Details
Using RANK() and DENSE_RANK()
Top 2 Sold Products
Leaderboard Soccer Ranking
Top Watched Videos
Using LAG and LEAD
MoM Change in Revenue
Revenue Change by Product Vertical
Congratulations
