Tell me claim 143's settled amount.
select amount_settled from claims where claim_id = 143
Tell me its number of settlements.
select count(*) from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id where t1.claim_id = 143
Which claims caused more than 2 settlements or have the maximum claim value? List the date the claim was made and the claim id.
select t1.date_claim_made, t1.claim_id from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id group by t1.claim_id having count(*) > 2 union select t1.date_claim_made, t1.claim_id from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id where t1.amount_claimed = ( select max(amount_claimed) from claims )