---

SELECT
    count(DISTINCT s.id) AS sharers_with_ev_payment
FROM ourpension.sharer s
WHERE EXISTS (
    SELECT 1
    FROM back_office.operation o
    JOIN back_office.transaction t
        ON t.operation_id = o.id

    LEFT JOIN back_office.account da
        ON da.id = t.debit_account_id

    LEFT JOIN back_office.account ca
        ON ca.id = t.credit_account_id

    WHERE o.operation_type_id IN (35, 37, 112, 173)
      AND o.effective_date >= DATE '2025-01-01'
      AND o.effective_date <  DATE '2025-02-01'

      AND (
          da.owner_sharer_id = s.id
          OR ca.owner_sharer_id = s.id
      )
);