Intermediate SQL Interview Drills: FLOOR 2
Seven minutes per problem, and every problem needs more than one table or more than one pass over the data.
Mission briefing
Floor 2 covers the intermediate SQL interview questions that separate real practice from syntax memorization. Map a chain of command with a self-join. Detect overlapping operations booked into the same safe house. Build a running budget total month by month. Find the top agent per division. Identify pairs of agents who share contacts.
These are the patterns behind questions asked in big-tech data screens: hierarchy traversal, range overlap, running aggregates, and top-N per group, each wrapped in a mission briefing with a server-enforced seven-minute timer.
Clear all five and Floor 3's advanced problems are waiting upstairs. Progress and best runs save to your account.
For the full format, timers, and scoring details, see the Interview Mode page.
Related guides
Free guides that pair well with this chapter:
Play Floor 2 now
Free in your browser, desktop only. Guest mode starts instantly with no signup; sign in with Google if you want progress saved across devices.