---

SELECT atcd.application_termination_contract_id, count(*)
FROM ourpension.application_termination_contract_data atcd
GROUP BY atcd.application_termination_contract_id
HAVING count(*) > 1