APPROX_QUANTILES

1
SELECT
2
  APPROX_QUANTILES(salary, 4) as salary_quartiles
3
FROM `project.dataset.employees`;

1
SELECT
2
  APPROX_QUANTILES(response_time_ms, 100)[OFFSET(50)] as p50,
3
  APPROX_QUANTILES(response_time_ms, 100)[OFFSET(90)] as p90,
4
  APPROX_QUANTILES(response_time_ms, 100)[OFFSET(99)] as p99
5
FROM `project.dataset.api_logs`;

1
SELECT
2
  product_category,
3
  APPROX_QUANTILES(price, 4) as price_distribution
4
FROM `project.dataset.products`
5
GROUP BY product_category;

1
SELECT
2
  department,
3
  APPROX_QUANTILES(salary, 2)[OFFSET(1)] as median_salary
4
FROM `project.dataset.employees`
5
GROUP BY department
6
ORDER BY median_salary DESC;