---

SELECT
    COUNT(*) AS total_rows,
    COUNT(et.strategy_id) AS with_strategy,
    COUNT(et.pens_schema_dt) AS with_debit_scheme,
    COUNT(et.pens_schema_ct) AS with_credit_scheme,
    COUNT(et.operation_sum) AS with_sum
FROM back_office.eps_transaction et
JOIN ourpension.eps e ON e.id = et.eps_id
WHERE e.service_type = 'NPO'
  AND et.oper_date >= DATE '2026-08-01'
  AND et.oper_date <  DATE '2026-09-01';