Practice DoorDash SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Aggregate order counts per restaurant to establish baseline volume.
Apply a window-based bucketing function to isolate the lowest-volume quartile.
Join the filtered restaurants back to raw transactions to count unique locations and customers.

What This Tests

Window functions for discrete data partitioning
Multi-step aggregation and relational joins
Behavior of ranking functions with tied values
Distinct counting across filtered subsets

Common Patterns

Window Function

Ranking

Aggregation

Inner Join

Test Cases

Input

-

Output

-

Expected

-