New
ML System Design & SQL tracks just landed
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
JobRadar
NEW
Referral
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
DoorDash
SQL Question
AI Insights
Quick Summary
Compute the elapsed time per order to assess delivery speed.
Use conditional logic to flag orders exceeding a 15-minute threshold.
Calculate the ratio of flagged orders to the total, scaled to a 0–100 percentage.
What This Tests
Date and time arithmetic
Conditional aggregation
Percentage scaling and rounding
Strict inequality boundary handling
Common Patterns
Aggregation
Date Arithmetic
Collapse
Hint
What Interviewers May Ask Next
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.6-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
