Which claims caused more than 2 settlements? Please 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
Which claim had the highest claim value? Please 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 order by t1.amount_claimed desc limit 1
What date was that claim made?
select t1.date_claim_made from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id order by t1.amount_claimed desc limit 1
What date was that claim settled?
select t1.date_claim_settled from claims as t1 join settlements as t2 on t1.claim_id = t2.claim_id order by t1.amount_claimed desc limit 1