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
Calculate two metrics with different denominators: one aggregated at the order level and one at the request level.
Identify which orders ever saw an increased offer and compute the average percentage increase across all individual attempts.
Handle cases where offers drop below the base amount by flooring the increase percentage at zero.
What This Tests
Managing multiple aggregation levels within a single query
Joining reference data to transactional records
Conditional calculations and value flooring
Isolating distinct denominators for independent metrics
Common Patterns
Inner Join
Aggregation
Subquery
Groupby
Collapse
Hint 1
Hint 2
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
-
