---

SELECT
    count(*) AS total_pensioners,
    count(*) FILTER (
        WHERE aibd.accepted::date <= DATE '2026-06-30'
    ) AS br_before_or_on_date,
    count(*) FILTER (
        WHERE aibd.accepted::date > DATE '2026-06-30'
    ) AS br_after_date,
    count(*) FILTER (
        WHERE aibd.id IS NOT NULL
          AND aibd.accepted IS NULL
    ) AS br_without_accepted_date,
    count(*) FILTER (
        WHERE aibd.id IS NULL
    ) AS br_not_found
FROM pens p
LEFT JOIN ourpension.application_individual_bank_detail aibd
    ON aibd.id = p.bank_detail_id;