-- Database schema
| Customers : Customer_ID [ INT ] primary_key , Customer_Details [ TEXT ] | Customer_Policies : Policy_ID [ INT ] primary_key , Customer_ID [ INT ] Customer_Policies.Customer_ID = Customers.Customer_ID , Policy_Type_Code [ TEXT ] , Start_Date [ TEXT ] , End_Date [ TEXT ] | Claims : Claim_ID [ INT ] primary_key , Policy_ID [ INT ] Claims.Policy_ID = Customer_Policies.Policy_ID , Date_Claim_Made [ TEXT ] , Date_Claim_Settled [ TEXT ] , Amount_Claimed [ INT ] , Amount_Settled [ INT ] | Settlements : Settlement_ID [ INT ] primary_key , Claim_ID [ INT ] Settlements.Claim_ID = Claims.Claim_ID , Date_Claim_Made [ TEXT ] , Date_Claim_Settled [ TEXT ] , Amount_Claimed [ INT ] , Amount_Settled [ INT ] , Customer_Policy_ID [ INT ] | Payments : Payment_ID [ INT ] primary_key , Settlement_ID [ INT ] Payments.Settlement_ID = Settlements.Settlement_ID , Payment_Method_Code [ TEXT ] , Date_Payment_Made [ TEXT ] , Amount_Payment [ INT ] |
-- -- Find the claim id and the number of settlements made for the claim with the most recent settlement date.

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;