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 )