select
f1 as 姓名,f2 as 身份证号码,case
when SUBSTRING(f2,11,4) between '0120' and '0218' then '水瓶座'
when SUBSTRING(f2,11,4) between '0219' and '0320' then '双鱼座'
when SUBSTRING(f2,11,4) between '0321' and '0419' then '白羊座'
when SUBSTRING(f2,11,4) between '0420' and '0520' then '金牛座'
when SUBSTRING(f2,11,4) between '0521' and '0621' then '双子座'
when SUBSTRING(f2,11,4) between '0622' and '0722' then '巨蟹座'
when SUBSTRING(f2,11,4) between '0723' and '0822' then '狮子座'
when SUBSTRING(f2,11,4) between '0823' and '0922' then '处女座'
when SUBSTRING(f2,11,4) between '0923' and '1023' then '天秤座'
when SUBSTRING(f2,11,4) between '1024' and '1122' then '天蝎座'
when SUBSTRING(f2,11,4) between '1123' and '1221' then '射手座'
else '摩羯座' end as 星座
from (select '张三' as f1,'000000201512070000' as f2) t1,