---

select
    rd.account,
    rd.pension_scheme_id,
    rd.uidpensionscheme,
    ps.name as scheme_name,
    ps.brief as scheme_brief,
    sum(
        coalesce(rd.sum_dt_pu, 0)
        - coalesce(rd.sum_ct_pu, 0)
    ) as s_pu,
    sum(
        coalesce(rd.sum_dt_bu, 0)
        - coalesce(rd.sum_ct_bu, 0)
    ) as s_bu
from back_office.report_conformity_pu_bu_detail rd
left join prod_line.pens_scheme ps
    on ps.id = rd.pension_scheme_id
where rd.report_conformity_pu_bu_id = 97
  and rd.account in ('38902', '39002')
group by
    rd.account,
    rd.pension_scheme_id,
    rd.uidpensionscheme,
    ps.name,
    ps.brief
order by
    rd.account,
    rd.pension_scheme_id,
    rd.uidpensionscheme;