STDDEV_POP

1
SELECT
2
  STDDEV_POP(score) as population_stddev,
3
  STDDEV_SAMP(score) as sample_stddev
4
FROM exam_results
5
WHERE class_id = 'CLASS-A';

1
SELECT
2
  region,
3
  ROUND(AVG(price), 2) as avg_price,
4
  ROUND(STDDEV_POP(price), 2) as stddev_pop,
5
  ROUND(STDDEV_POP(price) / AVG(price) * 100, 2) as cv_percent
6
FROM all_products
7
GROUP BY region;