Database: insurance_policies
Question: Find the claim id and the number of settlements made for the claim with the most recent settlement date.
SQL:
SELECT count(*) ,  T1.claim_id FROM Claims AS T1 JOIN Settlements AS T2 ON T1.claim_id  =  T2.claim_id GROUP BY T1.claim_id ORDER BY T1.Date_Claim_Settled DESC LIMIT 1