---

select
    acc as account,
    pension_scheme_id,
    strategy_id,
    contract_class_code,
    sum(sum_dt) as sum_dt_pu,
    sum(sum_ct) as sum_ct_pu
from temp_sum
group by
    acc,
    pension_scheme_id,
    strategy_id,
    contract_class_code;