---

and s.id = (
    select max(s2.id)
    from ourpension.sharer s2
    where s2.individual_id = atc.individual_id
      and s2.contract_id = c.id
)