STDDEV_POP

1
SELECT
2
  STDDEV_POP(score) as population_stddev,
3
  STDDEV_SAMP(score) as sample_stddev,
4
  STDDEV(score) as stddev_alias
5
FROM `project.dataset.exam_scores`;

1
SELECT
2
  department,
3
  AVG(salary) as avg_salary,
4
  STDDEV_POP(salary) as salary_stddev_pop
5
FROM `project.dataset.all_employees`
6
GROUP BY department
7
ORDER BY salary_stddev_pop DESC;

1
SELECT
2
  sensor_id,
3
  AVG(reading) as avg_reading,
4
  STDDEV_POP(reading) as reading_variability,
5
  MIN(reading) as min_reading,
6
  MAX(reading) as max_reading
7
FROM `project.dataset.sensor_data`
8
WHERE DATE(timestamp) = CURRENT_DATE()
9
GROUP BY sensor_id
10
ORDER BY reading_variability DESC
11
LIMIT 10;