STDDEV

1
SELECT
2
  product_category,
3
  AVG(price) as avg_price,
4
  STDDEV(price) as price_stddev,
5
  MIN(price) as min_price,
6
  MAX(price) as max_price
7
FROM `project.dataset.products`
8
GROUP BY product_category;

1
SELECT
2
  endpoint,
3
  AVG(response_time_ms) as avg_response,
4
  STDDEV(response_time_ms) as stddev_response,
5
  STDDEV(response_time_ms) / AVG(response_time_ms) as coefficient_of_variation
6
FROM `project.dataset.api_logs`
7
WHERE DATE(timestamp) = CURRENT_DATE()
8
GROUP BY endpoint
9
ORDER BY coefficient_of_variation DESC;

1
SELECT
2
  department,
3
  COUNT(*) as employee_count,
4
  AVG(salary) as avg_salary,
5
  STDDEV(salary) as salary_stddev,
6
  STDDEV(salary) / AVG(salary) * 100 as variability_pct
7
FROM `project.dataset.employees`
8
GROUP BY department
9
HAVING COUNT(*) >= 5
10
ORDER BY variability_pct DESC;