CASE When的应用

select
  CASE
    when age < 25
    or age is null then '25岁以下'
    when age >= 25 then '25岁及以上'
  end age_cut,
  count(*) number
from
  user_profile
group by
  age_cut