sql提取身份证号信息--省市区县，年龄分组

sql提取身份证号信息--省市区县，年龄分组

insert into test009
select 
 t8.name
,t8.mobile
,t8.idcard
,t8.birthday
,t8.age
,t8.sex
,t8.property
,t8.constellation
,t8.province
,t8.age_group
,t8.six_idcard
,apa.desc1
,t8.create_date
from 
(select 
zone
,desc1
from apo_areacode
) as apa
right join
(select
 name
,mobile
,idcard
,birthday
,age
,sex
,property
,constellation
,province
,six_idcard
,create_date
,(case when age<20 then '20岁以下'
         when age>=20 and age <=29 then '20~29岁'
				 when age>=30 and age <=39 then '30~39岁'
				 when age>=40 and age <=49 then '40~49岁'
				 when age>=50 and age <=59 then '50~59岁'
				 when age>=60 then '60岁及以上'
				 else null end)age_group
from test008) as t8
on apa.zone = t8.six_idcard
;