类似,参考
select 身份证号,姓名,年龄,年, sum(申请月数) as 已申请月数 from (select a.身份证号, 姓名, 年龄, 年, 季, 申请月数, 申请金额 from {a} left join {b} on {a}.身份证号={b}.身份证号) as test group by 身份证号,姓名,年龄,年