NTILE Function

NTILE(n) divides rows into n equal buckets:

NTILE(4) OVER(ORDER BY price) -- splits into 4 quartiles

Your Task

Divide products into 3 price tiers:

• name, price
• price_tier (1 = low, 2 = medium, 3 = high)

Order by price_tier, then price.