Database: insurance_policies
Question: Find the number of settlements each claim corresponds to. Show the number together with the claim id.
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