QUANTILE

1
SELECT
2
  category,
3
  QUANTILE(price, 0.25) as Q1,
4
  QUANTILE(price, 0.50) as median,
5
  QUANTILE(price, 0.75) as Q3
6
FROM products
7
GROUP BY category;

1
SELECT
2
  region,
3
  QUANTILE(salary, [0.1, 0.5, 0.9]) as salary_distribution
4
FROM employees
5
GROUP BY region;

1
SELECT
2
  endpoint,
3
  QUANTILE(response_ms, 0.50) as p50,
4
  QUANTILE(response_ms, 0.90) as p90,
5
  QUANTILE(response_ms, 0.99) as p99,
6
  MAX(response_ms) as max_response
7
FROM api_logs
8
WHERE log_date = CURRENT_DATE
9
GROUP BY endpoint
10
ORDER BY p99 DESC;