DoorDash Interview Question

Read 4 questions in a Coderpad and solve them with SQL in under 20 minutes

Interview Answers

Anonymous

Sep 17, 2020

Typical questions, but difficult because of time pressure. It was difficult for me to read 4 questions, write 4 solutions, and discuss 4 answers in 20 minutes. I finished 2.5 problems. SQL problems were complex involving case statements, left joins, aggregates, subqueries, and date-time conversions. You can “google”, but this is mostly a distraction and will waste time. Just know SQL syntax and how to solve these problems automatically. Practice with a whiteboard or notepad so you aren’t tempted to build statements modularly. In my opinion, this was very difficult as far as DS SQL tests go, but might be relevant to their needs.

1

Anonymous

Jan 27, 2021

There's quite an extended back and forth in actual interviews for questions like this, so nothing quite like real practice. The Prepfully DoorDash Data Scientist experts have actually worked in this role, so they're able to do an honest-to-God accurate mock, which really puts you through the paces. prepfully.com/practice-interviews