How many settlements were made on the claim with the most recent claim settlement date? List the number and the claim id.
create table settlements (claim_id varchar, PRIMARY KEY (claim_id)); create table claims (claim_id varchar, date_claim_settled varchar, PRIMARY KEY (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