子查询的想法和“ CASE WHEN”一样有效，然后按以下方式进行分组：
SELECt SUM(field1), bucket FROM ( SELECt field1, CASE WHEN age >= 0 AND age < 10 THEN 1 WHEN age >= 10 AND age < 20 THEN 2 WHEN age >= 20 AND age < 30 THEN 3 ... ELSE -1 END as bucket FROM table1) GROUP BY bucket
或者，如果存储桶是规则的，则可以将它们除并转换为整数：
SELECt SUM(field1), bucket FROM ( SELECt field1, INTEGER(age / 10) as bucket FROM table1)GROUP BY bucket
