---

SELECT
    count(*) AS total_pensioners,
    count(*) FILTER (
        WHERE EXISTS (
            SELECT 1
            FROM ourpension.application_individual_bank_detail newer
            WHERE newer.sharer_id = p.sharer_id
              AND newer.id <> original.id
              AND newer.accepted > original.accepted
              AND newer.accepted::date <= DATE '2026-06-30'
        )
    ) AS pensioners_with_newer_br
FROM pens p
JOIN ourpension.application_individual_bank_detail original
    ON original.id = p.bank_detail_id;