Practice SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

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

Accepted

30/106

Acceptance Rate28.3%

Test Cases

Input

-

Output

-

Expected

-