SELECT CASE WHEN age BETWEEN 0 AND 30 THEN '30岁及以下' WHEN age BETWEEN 31 AND 40 THEN '31岁-40岁' WHEN age BETWEEN 41 AND 50 THEN '41岁-50岁' WHEN age BETWEEN 51 AND 55 THEN '51岁-55岁' ELSE '55岁以上' END AS age_group, COUNT(1)FROM sdhy_dwd.dwd_rl_ryjbxxwhere 1=1 ${if(organ == "集团整体","","AND fatherorg_shortname = '${organ}'")}GROUP BY age_groupORDER BY MIN(age_group)