Tell me the number of settlements of claim 957
select count(*) from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id where t1.claim_id = 957
How about the settlement claim amount?
select t2.amount_claimed from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id where t1.claim_id = 957
Which claim incurred the most number of settlements? List the claim id, the date the claim was made, and the number
select t1.claim_id, t1.date_claim_made, count(*) from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id group by t1.claim_id order by count(*) desc limit 1