New
The Learning module is now live
See what's new
×
Question Bank
Learning
NEW
Pricing
Blog
Forum
HOT
JobRadar
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
DoorDash
SQL Question
AI Insights
Quick Summary
Calculate monthly order counts per customer.
Exclude customers exceeding the high-frequency threshold of 30 orders.
Rank remaining customers by order count and select the top one per month.
What This Tests
Multi-step aggregation and conditional filtering
Window functions for partitioned ranking
Deterministic tie-breaking logic
Month-based date extraction and grouping
Common Patterns
Aggregation
Window Function
Ranking
Sort
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
Accepted
39
/157
Acceptance Rate
24.8%
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.7-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
