Table 1: food_delivery
***_**** | ***_**** ---------------+------------------- *****_** | ****** *******_** | ****** *********_** | ********* ****** | *** (1,...,5)
Question 136
Extremely late orders
Premium Access
Unlock this Doordash interview question.
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
- 230+ interview questions
- Official solutions
- SQL, Python, and R tracks
- ** * **** ***** ** ********* ****** ** ***** **** (>=) 60 *******, **** ***** ** ********** ** '********* **** *****'.
- ***** * ***** ** ****** *** ********** ** ********* **** ****** ** ***** ** 2021.
- *** **********, ** ****** ***** ***** *** *********.
- *** ******** ******** ** ******* ******* **** *** **** *********: ****_* *** ****_* (****_* > ****_*) **:
-
******* (***** **** ****_* - ****_*)::***/60
-
Table 2: food_order
**** ****** **** *** ****** ** ********.
***_**** | ***_**** ---------------+------------------- *****_** | ****** **********_** | ****** ********_** | ****** *******_** | ********* *****_*** | *****
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Copied
Expected results
Submit a query to compare against expected output.
Interview timer
Recommended interview pacing
Easy: 5 min for direct warm-up style questions.
Medium: 10 min for multi-step interview queries.
Hard: 15 min for layered questions with tighter time pressure.
A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.
5:00
Your results
Run your query to preview results here.