---

SELECT
    count(DISTINCT opaa.id) AS applications_without_br_filter,
    count(DISTINCT opaa.id) FILTER (
        WHERE aibd.accepted::date = DATE '2026-06-30'
    ) AS applications_with_br_filter,

    count(DISTINCT i.id) AS people_without_br_filter,
    count(DISTINCT i.id) FILTER (
        WHERE aibd.accepted::date = DATE '2026-06-30'
    ) AS people_with_br_filter
FROM ourpension.ops_pension_assignment_application opaa
JOIN ourpension.sharer s
    ON s.id = opaa.sharer_id
JOIN ourpension.contract c
    ON c.id = s.contract_id
JOIN ourpension.individual i
    ON i.id = c.individual_id
JOIN ourpension.address a
    ON a.id = i.registration_address_id
LEFT JOIN ourpension.application_individual_bank_detail aibd
    ON aibd.id = opaa.bank_detail_id
WHERE opaa.ops_payment_type_code = '05'
  AND opaa.appeal_date <= DATE '2026-06-30';