失业台账生成，新旧数据比对

--5987
select count(1)
  from zsuser.uepsacp a
 where (a.uasty * 100 + a.uastm) >= 201801
   and trim(a.uazone) in
       ('Z400', 'Z401', 'Z402', 'Z403', 'Z404', 'Z406', 'Z409');
--5987
SELECT count(1)       
  from ac60 a,
       jc10 f,
       AC63 c,
       (select d.aaz257, sum(e.aae019) aae019
          from ac60 d, ac61 e
         where d.aaz257 = e.aaz257
           and d.aae100 = '1'
           and d.aae116 = '1'
           and d.aae140 = '210'
           and d.aae210 <= 201801
           and d.aic301 >= 201801
           and e.aae042 >= 201801
           and d.aaa027 = '440300'
           and d.baf307 = '440306'
         group by d.aaz257) g
 where a.aaz257 = f.aaz257
   and a.aaz099 = c.aaz099
   and a.aaz257 = g.aaz257;
  
select * from aa10 a where a.aaa100='BAF307';