---

select
    e.classification,
    e.contract_model_label as eps_model,
    et.contract_class_code,
    et.contract_model_label as transaction_model,
    count(*) as transaction_count
from back_office.eps_transaction et
join ourpension.eps e
    on e.id = et.eps_id
where e.service_type = 'NPO'
  and e.periodicity in (1, 2)
  and et.oper_date >= date '2026-09-01'
  and et.oper_date < date '2026-10-01'
group by
    e.classification,
    e.contract_model_label,
    et.contract_class_code,
    et.contract_model_label
order by 1, 2, 3, 4;