Skip to content

Tracks

AI-assisted engineering Working with AI Agents System design Core systems Data and AI systems Coding Coding problems Code review On-call SQL

Practice

Paths Concept guides

FreeAd-supported

The plan adds AI feedback and removes ads.

Concept guides/SQL/Window functions

Window functions

Hard6 min read

Questions it teaches

Rank pay within each teamMedium11 min Running total of order valueMedium11 min Each order as a share of the totalMedium12 min Distance from the team averageHard12 min Most recent order for each customerHard13 min The second-highest salary in each departmentHard14 min A running total of revenue by dateHard14 min Each salary against the department bestHard12 min

Related

SQL Databases in production

Leads to: Databases in production

Database disk saturation (IOPS)3 min Database unreachable3 min

© 2026 Prep Room·From California·AI can make mistakes.

About Legal Contact Cookies Your privacy choices

Home Review Tracks Paths