Instacart·Software Engineer·Technical Phone Screen
- Write a SQL query to find the least efficient driver based on deliveries completed per hour of driving time over the last two months.
“The SQL itself wasn't the hard part.”
Large Enterprises
Most of these Instacart write-ups come from Software Engineers (88), then Data Scientists (28) and Machine Learning Engineers (5). The most reported rounds are the technical phone screen (93), the system design round (13), the behavioral / leadership round (6) and the product sense round (6).
128 interview notes · updated Jul 2026
“The SQL itself wasn't the hard part.”
“This is a meaty one.”
“The simple cases like '3[a]2[bc]' are easy enough to reason through, but the nested version like '3[a2[c]]' is where I had to slow down and actually think about the stack structure.”
“My first instinct was to just randomly sample the whole list, which is wrong because you'd skew the OD distribution.”
“I went with recursive descent because I can never remember the two-stack approach under pressure, and it felt more natural to reason about.”
“The single-clerk version felt manageable.”
“The coordinate system tripped me up for a second because [0,0] being bottom-left means you have to flip the row index.”
“I started with a sorted list per key and binary search, which is the obvious answer.”
“Pretty standard ranking query but the title filter is where people slip up if they apply it after the ranking instead of before.”
“This question is basically five system design questions stapled together.”