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 the percentage of customers placing over 30 orders per month.
Requires two-stage aggregation: first by customer within each month, then summarized by month.
Outputs monthly metrics including active customer count and high-frequency percentage.
What This Tests
Multi-step data aggregation and grouping
Conditional counting and ratio calculation
Date extraction and monthly bucketing
Handling nested or grouped metric computations
Common Patterns
Aggregation
Groupby
Date Arithmetic
Collapse
Hint 1
Hint 2
Hint 3
What Interviewers May Ask Next
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
-
