VAR_SAMP

1
SELECT
2
  region,
3
  COUNT(*) as sample_size,
4
  ROUND(AVG(satisfaction_score), 2) as avg_score,
5
  ROUND(VAR_SAMP(satisfaction_score), 2) as score_variance
6
FROM customer_survey
7
GROUP BY region;

1
SELECT
2
  VAR_SAMP(price) as variance,
3
  STDDEV_SAMP(price) as stddev,
4
  SQRT(VAR_SAMP(price)) as stddev_from_var,
5
  POWER(STDDEV_SAMP(price), 2) as var_from_stddev
6
FROM products;