select * from (SELECT s_staff,s_branch,s_copr,s_grid FROM "XJPD"."STAFF_POOL") aleft join (select b_group,b_all,re_all,re_a,re_c,(case b_all when 0 then 0 else RE_all/B_all end) as myd_all,(case re_all when 0 then 0 else re_a/re_all end) as myd_afrom(select b_group,count(case when B_SERVICE_type is not null then b_group else null end) as b_all ,count(case when b_install_visit is not null then b_group else null end) as RE_all ,count(case when b_install_visit ='A' then b_group else null end) as RE_A ,count(case when b_install_visit ='C' then b_group else null end) as RE_C from "XJPD"."BROADBAND_POOL" group by b_group))b on a.s_grid=b.b_group
