QUANTILE_CONT

1
SELECT
2
  department,
3
  QUANTILE_CONT(salary, 0.5) as median_salary,
4
  QUANTILE_CONT(salary, 0.9) as p90_salary
5
FROM employees
6
GROUP BY department;

1
SELECT
2
  product_type,
3
  QUANTILE_CONT(rating, [0.25, 0.5, 0.75]) as rating_quartiles
4
FROM product_reviews
5
GROUP BY product_type;

1
SELECT
2
  service_name,
3
  ROUND(QUANTILE_CONT(latency_ms, 0.50), 2) as p50,
4
  ROUND(QUANTILE_CONT(latency_ms, 0.95), 2) as p95,
5
  ROUND(QUANTILE_CONT(latency_ms, 0.99), 2) as p99
6
FROM service_metrics
7
WHERE timestamp >= NOW() - INTERVAL '1 hour'
8
GROUP BY service_name
9
HAVING QUANTILE_CONT(latency_ms, 0.99) > 100;