WhiteBox
Problems
Core Catalog
Real interview problems not on LeetCode
Algorithms
Sharpen problem solving with handpicked DSA problems
Domain Knowledge
Quiz yourself
Library
Curated resources, tier lists, and problem sets
Guides
Real takes worth your time reading
White Room
White Room
Your AI coach, plan, and memory
White Room DSA
Adaptive problems dealt at your level
What is White Room?
Community
Leaderboard
See top WhiteBox performers
Refer & Earn
Get your friends on WhiteBox
Shop
Customize your profile
Contributors
Meet the team behind WhiteBox
Changelog
See what's new on WhiteBox
Tools
Interview Intel
Questions pulled from real interviews
Resume Reviewer
See your resume the way a recruiter does
Job Boards
Land your dream job
Sandbox IDE
Solve Codeforces, AtCoder, and CSES in-browser
Search
Ctrl K
Login
Sign up
Log in
Practice
Core Catalog
Algorithms
Domain Knowledge
Library
Guides
White Room
White Room
White Room DSA
Community
Leaderboard
Refer & Earn
Shop
Contributors
Changelog
Tools
Interview Intel
Resume Reviewer
Job Boards
Sandbox IDE
Back
All Modules
Data Management
SQL Window Functions & Advanced
SQL Window Functions & Advanced
0 / 6 solved
0/6
solved
Status
All questions
6
Unsolved
6
Solved
0
Tags
Basics
1
clause-order
1
first-value
1
frame-clause
2
hierarchies
1
last-value
1
peers
1
ranking-functions
1
recursive-cte
1
rows-vs-range
1
running-total
1
top-n-per-group
1
window-functions
2
working-table
1
Difficulty
1
10
Clear
Question
Tags
Difficulty
Success
1.
Third Or Second Place
ranking-functions
peers
+1
Medium
—
2.
SQL Window Function Ordering
Basics
Medium
100%
3.
Top Three Per Customer
window-functions
clause-order
+1
Medium
—
4.
Last Value Is Not Last
frame-clause
first-value
+1
Medium
—
5.
One Level At A Time
recursive-cte
hierarchies
+1
Medium
—
6.
The Running Total Jumps
frame-clause
rows-vs-range
+1
Hard
—
ranking-functions
peers
window-functions
Basics
clause-order
top-n-per-group
frame-clause
first-value
last-value
recursive-cte
hierarchies
working-table
rows-vs-range
running-total
+1
+2
+3
Problems
Roadmap
White Room
Guides
Log in