Find the number of settlements each claim corresponds to. Show the number together with the claim id.
select t1.claim_id, count(*) from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id group by t1.claim_id