Skip to content
Skills
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Home
/
Data Analyst
/
Questions
/
Window Functions
Data Analyst
Window Functions questions
7 questions on Window Functions for data analysts, easiest first.
Medium
4
Latest order per customer
medium
Running total of sales
medium
RANK vs DENSE_RANK after a tie
medium
Month-over-month change with LAG
medium
Hard
3
Running total with tied dates
hard
NTILE with 10 rows
hard
Latest order changes between runs
hard
