Technical Screen

Recycled SQL Questions and a Biker-Project Case Round

DoorDashData Scientist · Technical Screen · Nov 2025

HR screen -> Round 1 30-min SQL round: 4 old/frequently-asked questions, with my basic approach: Q1. Percentage of high frequency customers (order>30) each month. Get cus_id, month, order_count. Group by month, cus; count(distinct case when oc> then cus end)/count(distinct cus) Q2. Customers who ordered the most, excluding high-frequency customers, each month (follow-up: the most frequent custome…

Shared by a candidate · reported Nov 2025. Interview formats change; use it as a guide, not a script.