NTILE Buckets — Solution & ExplanationProblems / NTILE Buckets / EditorialApproachNTILE(n) divides an ordered partition into n roughly equal groups and assigns each row a group number.

NTILE(4): Creates 4 groups (quartiles).

ORDER BY price: Products are sorted by price before grouping.

Distribution: With 16 products, each quartile gets exactly 4. If the count doesn't divide evenly, earlier groups get one extra row.

This is commonly used for percentile analysis, salary bands, or segmenting customers into tiers.Hints

NTILE(n) distributes rows into n approximately equal-sized groups.

ORDER BY price ensures the cheapest products go into bucket 1.

With 16 rows and 4 buckets, each bucket gets exactly 4 rows.

Solve NTILE Buckets yourself →