---

SELECT
    count(*) AS total,

    count(*) FILTER (
        WHERE aibd.accepted = DATE '2026-08-28'
    ) AS exact_match,

    count(*) FILTER (
        WHERE aibd.accepted::date = DATE '2026-08-28'
    ) AS date_match

FROM ourpension.ops_pension_assignment_application opaa

LEFT JOIN ourpension.application_individual_bank_detail aibd
    ON aibd.id = opaa.bank_detail_id

WHERE opaa.ops_payment_type_code = '05'
  AND opaa.registration::date = DATE '2026-08-28';