1、mysql语句实现年龄分布
select nnd as '年龄段',count(*) as '人数' from(

 select

 case

  when age>= and age<= then '1-10'

  when age>= and age<= then '11-20'

  when age>= and age<= then '21-30'

  when age>= and age<= then '31-40'

  when age>= and age<= then '41-50'

  when age>= and age<= then '51-60'

  when age>= and age<= then '61-70'

  when age>= and age<= then '71-80'

  when age>= and age<= then '81-90'

  when age>= and age<= then '91-100'

 ELSE '无年龄' end

 as nnd from doc_info

)a group by nnd
2、查找病历中包含逗号的诊断数量
SELECT count(diag) FROM `doc_info_hive` where LOCATE(',',diag)>0  ;
3、查找病例中不包含逗号的诊断数量
SELECT count(diag) FROM `doc_info_hive` where LOCATE(',',diag)=0  ;