如何在MySQL中计算诸如年龄组的值？
如何在MySQL中计算诸如年龄组的值？
提问于 2022-11-10 10:35:24
这里我有数据集，包括企业客户的年龄，我想在一个新的专栏中创建一个年龄组，比如"18-24"，"25-34“等等，我可以使用什么语法？
在google上搜索，我找到了这个查询
SELECT Year_Birth,
CASE
WHEN Year_Birth BETWEEN 1990 AND 1996 THEN "18-24"
WHEN Year_Birth BETWEEN 1989 AND 1980 THEN "25-34"
WHEN Year_Birth BETWEEN 1979 AND 1970 THEN "35-44"
WHEN Year_Birth BETWEEN 1969 AND 1960 THEN "45-54"
WHEN Year_Birth BETWEEN 1959 AND 1950 THEN "55-64"
ELSE "65+"
END as Age_group,
COUNT(*) AS count
FROM marketing_campaign;但似乎这不起作用
回答 1
Stack Overflow用户
回答已采纳
发布于 2022-11-10 10:41:25
只需将此字段添加到GROUP BY子句：
SELECT Year_Birth,
CASE
WHEN Year_Birth BETWEEN 1990 AND 1996 THEN "18-24"
WHEN Year_Birth BETWEEN 1989 AND 1980 THEN "25-34"
WHEN Year_Birth BETWEEN 1979 AND 1970 THEN "35-44"
WHEN Year_Birth BETWEEN 1969 AND 1960 THEN "45-54"
WHEN Year_Birth BETWEEN 1959 AND 1950 THEN "55-64"
ELSE "65+"
END as Age_group,
COUNT(*) AS count
FROM marketing_campaign
GROUP BY Age_group;请注意，那一定是一篇旧文章，那个算术现在已经很远了.使此查询年复一年地工作是另一个问题，但您的问题中没有涉及。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/74387568
复制相关文章
相似问题
腾讯云开发者
