About how many settlements does each claim correspond to?
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
settlements corresponds to each claim refers to joining Claims and Settlements on claim_id and counting the number of settlements for each claim;