select * from (SELECT s_staff,s_branch,s_copr,s_grid FROM "XJPD"."STAFF_POOL") a

left 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_a

from

(

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