---

select
    code,
    name
from ourpension.contract_statuses
where name ilike '%прекращ%'
   or name ilike '%расторг%'
   or name ilike '%закры%'
order by code;