---

select
    rd.report_conformity_pu_bu_id as report_id,
    count(*) as detail_rows,
    count(*) filter (
        where rd.sum_dt_pu is not null
           or rd.sum_ct_pu is not null
    ) as rows_with_pu,
    count(*) filter (
        where rd.sum_dt_bu is not null
           or rd.sum_ct_bu is not null
    ) as rows_with_bu,
    sum(coalesce(rd.sum_dt_pu, 0)) as total_dt_pu,
    sum(coalesce(rd.sum_ct_pu, 0)) as total_ct_pu,
    sum(coalesce(rd.sum_dt_bu, 0)) as total_dt_bu,
    sum(coalesce(rd.sum_ct_bu, 0)) as total_ct_bu
from back_office.report_conformity_pu_bu_detail rd
where rd.report_conformity_pu_bu_id in (85, 92)
group by rd.report_conformity_pu_bu_id
order by rd.report_conformity_pu_bu_id;