Database: insurance_policies
Question: How many settlements does each claim correspond to? List the claim id and the number of settlements.
SQL:
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