NTILE

1
SELECT 
2
  name,
3
  salary,
4
  NTILE(4) OVER (ORDER BY salary) AS quartile
5
FROM employees;

1
SELECT 
2
  customer_id,
3
  total_purchases,
4
  CASE NTILE(3) OVER (ORDER BY total_purchases DESC)
5
    WHEN 1 THEN Gold
6
    WHEN 2 THEN Silver
7
    WHEN 3 THEN Bronze
8
  END AS tier
9
FROM customer_stats;

1
SELECT 
2
  NTILE(10) OVER (ORDER BY score) AS decile,
3
  MIN(score) AS min_score,
4
  MAX(score) AS max_score,
5
  COUNT(*) AS count
6
FROM test_results
7
GROUP BY decile
8
ORDER BY decile;