---

select
    c.npo_agreement_id,
    count(*) as cnt
from ourpension.contract c
where c.service_type = 'NPO'
  and c.npo_agreement_id is not null
  and btrim(c.npo_agreement_id) <> ''
group by c.npo_agreement_id
order by cnt desc
limit 20;