case-when-then

╰+哭是因爲堅強的太久メ 2022-01-20 06:57 373阅读 0赞

select t.ageRang, count(t.ageRang) as totalCount from (
select patient_name, 
case 
 when patient_age >= 20 and patient_age <= 29 then '20-29岁'
 when patient_age > 29 and patient_age <=39 then '30-39岁'
 when patient_age > 39 and patient_age <= 49 then '40-49岁'
 when patient_age > 49 and patient_age <=59 then '50-69岁'
 when patient_age > 59 then '60岁及以上'
 when (patient_age < 20 or age_unit in ('月', '天')) then '20岁以下'
 else '其它'
 end as ageRang
from online_academic_data where online_academic_id ='719'
) t group by t.ageRang
复制代码