---

SELECT
    count(DISTINCT opaa.id) AS applications,
    count(DISTINCT i.id) AS people
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'
  AND aibd.accepted::date <= DATE '2026-06-30';