Нужна помощь по запросу

select
  d.name,
  bm.fio_all,
  o.name,
  sum(s.summa) allsumma,
  (
    select
      iif(sum(ss.summa)>0,sum(ss.summa),0)
    from salaryr ss
    left join bdcode bcc on (bcc.id_code = ss.id_code)
    where
      (ss.yearrem = 2005) and
      ((ss.monthrem > 3) and (ss.monthrem < 7))  and
      (ss.id_kadr = s.id_kadr) and
      (bcc.name_code in (112,113))
  ) otpusk,
  sum(iif(bc.name_code in (152),s.summa,0)) premij
from salaryr s
left join bdcode bc on (bc.id_code = s.id_code)
left join data_work dw on (dw.id_datawork = s.id_datawork)
left join office o on (o.codedol = dw.codedol)
left join bdkadr_m bm on (bm.id_kadr = s.id_kadr)
left join depat d on (d.id_dep = dw.id_dep)
where
  (s.year_sis = 2005) and
  ((s.month_sis > 3) and (s.month_sis < 7))  and
  (bc.name_code in (101,103,104,105,107,108,115,118,119,126,133,137,141,142,143,145,146,
                    149,154,152,155,156,157,158,159,162,165,166,173,136,172,171))
group by
  d.name,
  bm.fio_all,
  o.name

select
  d.name,
  bm.fio_all,
  o.name,
  sum(s.summa) allsumma,
  (
    select
      sum(case
            when (ss.summa>0) then ss.summa
            else 0
          end
      )
    from salaryr ss
    left join bdcode bcc on (bcc.id_code = ss.id_code)
    where
      (ss.yearrem = 2005) and
      ((ss.monthrem > 3) and (ss.monthrem < 7))  and
      (ss.id_kadr = s.id_kadr) and
      (bcc.name_code in (112,113))
  ) otpusk,
  sum(case
        when (bc.name_code in (152)) then s.summa
        else 0
      end
  ) premij
from salaryr s
left join bdcode bc on (bc.id_code = s.id_code)
left join data_work dw on (dw.id_datawork = s.id_datawork)
left join office o on (o.codedol = dw.codedol)
left join bdkadr_m bm on (bm.id_kadr = s.id_kadr)
left join depat d on (d.id_dep = dw.id_dep)
where
  (s.year_sis = 2005) and
  ((s.month_sis > 3) and (s.month_sis < 7))  and
  (bc.name_code in (101,103,104,105,107,108,115,118,119,126,133,137,141,142,143,145,146,
                    149,154,152,155,156,157,158,159,162,165,166,173,136,172,171))
group by
  d.name,
  bm.fio_all,
  o.name

  sum(
    select
      sum(case
            when (ss.summa>0) then ss.summa
            else 0
          end
      )
    from salaryr ss
    left join bdcode bcc on (bcc.id_code = ss.id_code)
    where
      (ss.yearrem = 2005) and
      ((ss.monthrem > 3) and (ss.monthrem < 7))  and
      (ss.id_kadr = s.id_kadr) and
      (bcc.name_code in (112,113))
  ) otpusk,