使用SQL (Bigquery)在百分比列上创建桶

Question

我试图在转换列BigQuery上使用SQL ( 数据 )创建存储桶。请参考Dataset_2。

我编写了下面的查询，但我只得到一行。

结果：

排桶

1 >50

SELECT
  buckets
FROM (
  SELECT
    Conversion__,
    CASE
      WHEN Conversion__ > 30 AND Conversion__ <=40 THEN '31-40'
      WHEN Conversion__ > 40 AND Conversion__ <=50 THEN '41-50'
    ELSE '>50'
  END
    AS buckets
  FROM
    data_2) t2
GROUP BY
  buckets

Answer 1

试着在下面

SELECT
  CASE
    WHEN Conversion__ > 30 AND Conversion__ <=40 THEN '31-40'
    WHEN Conversion__ > 40 AND Conversion__ <=50 THEN '41-50'
    ELSE '>50'
  END AS buckets, 
COUNT(*) AS cnt  
FROM data_2
GROUP BY buckets          

如果应用于所提供的示例数据，则输出为

​

​