Practice Meta SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Count distinct accounts per user while filtering out duplicate rows.
Map each user's account total to fixed categorical buckets.
Return all required buckets with correct counts, preserving zeros and enforcing order.

What This Tests

Aggregation and grouping with deduplication
Conditional categorization of numerical aggregates
Joining computed results with reference/sentinel tables
Preserving sparse categorical outputs

Common Patterns

Deduplication

Groupby

Transform

Left Join

Test Cases

Input

-

Output

-

Expected

-