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

Compute percentage of orders with 3+ requests and average requests per order.
Must include orders with zero requests in all calculations and denominators.
Return results in a single row rounded to two decimal places.

What This Tests

Preserving base records with outer joins.
Handling NULL values in aggregate functions.
Conditional aggregation logic.
Multi-metric computation in a single pass.

Common Patterns

Left Join

Aggregation

Subquery

Test Cases

Input

-

Output

-

Expected

-