Bigquery 統計値

--統計値
SELECT
  max_value,
  min_value,
  mean_value,
  sd,
  -- 変動係数
  sd / mean_value AS hendou,
  -- 第一四分位数
  percentiles[offset(25)] AS per_25,
  -- 中央値
  percentiles[offset(50)] AS per_50,
  -- 第三四分位数
  percentiles[offset(75)] AS per_75,
FROM
(
　SELECT 
  APPROX_QUANTILES(value,100) percentiles,
  -- 最大値
  MAX(value) AS max_value,
  -- 最小値
  MIN(value) AS min_value,
  -- 平均値
  AVG(value) AS mean_value,
  -- 標準偏差
  STDDEV(value) AS sd,
 FROM
  table_1
 )