单选

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_ryjbxx

where 1=1 ${if(organ == "集团整体","","AND fatherorg_shortname =  '"+organ+"'")}

GROUP BY age_group

ORDER BY MIN(age_group)

多选

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_ryjbxx

where 1=1 ${if(organ == "集团整体","","AND fatherorg_shortname in ('"+organ+"')")}

GROUP BY age_group

ORDER BY MIN(age_group)

organ 设置如下

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_ryjbxx

 where 1 = 1

 ${if(organ == "集团整体", "", "AND fatherorg_shortname = '"+organ+"'") }

 GROUP BY 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

order by age_group