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
Aggregate transaction values into monthly buckets for a specific year.
Compute the percentage change between each month and its immediate predecessor.
Gracefully handle the starting month where historical data is unavailable.
What This Tests
Temporal data grouping and filtering
Row-wise historical comparison within a single query
Boundary condition handling for missing prior records
Numerical rounding and floating point arithmetic
Common Patterns
Aggregation
Window Function
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
-
