BigQuerySample

## 平均値
SELECT
  AVG(x)
FROM
  [projectName:dataSetName.tableName]
LIMIT
  1000
  
[
   426.842105263157
]

## Count1

SELECT
  COUNT(x)
FROM
  [projectName:dataSetName.tableName]
LIMIT
  1000
  
[
   95
]

## Count2

SELECT
  COUNT(x) AS count,
  x
FROM
  [projectName:dataSetName.tableName]
GROUP BY
  x
LIMIT
  1000
  
[
   count=>20
   x=>1465
]

## Count & OrderBy

SELECT
  COUNT(x) AS count,
  x,
  y
FROM
  [datasetName:dataSetName.tableName]
GROUP BY
  x,
  y
ORDER BY
  count DESC
LIMIT
  5000

[
 count=>2,
 x=>200,
 y=>100
]

## Count & SUM & OrderBy

SELECT
  COUNT(x) AS count,
  SUM(x) AS sum,
  x,
  y
FROM
  [datasetName:dataSetName.tableName]
GROUP BY
  x,
  y
ORDER BY
  count DESC
LIMIT
  5000

[
 count=>2,
 sum=>400,
 x=>200,
 y=>100
]
  
## ビット単位 AND

SELECT
  BIT_AND(x)
FROM
  [datasetName:dataSetName.tableName]
LIMIT
  1000
    
[
   144
]

## ビット単位 OR

SELECT
  BIT_OR(x)
FROM
  [projectName:dataSetName.tableName]
LIMIT
  1000
  
[
   1471
]

## ビット単位 XOR

SELECT
  BIT_XOR(x)
FROM
  [projectName:dataSetName.tableName]
LIMIT
  1000
  
[
    150
]

## 標準偏差
SELECT
  STDDEV(x)
FROM
  [projectName:dataSetName.tableName]
LIMIT
  1000
  
[
    150
]

## 重複業を除外してカウント
SELECT
  COUNT(distinct x)
FROM
   [projectName:dataSetName.tableName]
[
    3 
]