Tell me the settlement amount of settlement 564.
select amount_settled from settlements where settlement_id = 564
What is the date on which the claim was made?
select date_claim_made from settlements where settlement_id = 564
How many settlements were made on the claim with the most recent claim settlement date? Tell me the number and the claim id.
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