[bigquery]平均値と中央値を算出する方法

2023-08-14 2023-08-18

SELECT

AVG(price) as avg_value, -- 平均値

APPROX_QUANTILES(price, 2)[OFFSET(1)] as median_value -- 中央値

FROM

dataset.table

SELECT AVG(price) as avg_value, -- 平均値 APPROX_QUANTILES(price, 2)[OFFSET(1)] as median_value -- 中央値 FROM dataset.table

SELECT 
  AVG(price) as avg_value,  -- 平均値
  APPROX_QUANTILES(price, 2)[OFFSET(1)] as median_value -- 中央値
FROM 
  dataset.table

上記のpriceのところを任意の項目に変えれば、平均値と中央値が算出可能。