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 )
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 )
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 ( * ) > value 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 )
Which claims caused more than 2 settlements or have the maximum claim value ? List the date the claim was made and the claim id .