CREATE TABLE settlements (settlement_id NUMBER, claim_id NUMBER, date_claim_made TIME, date_claim_settled TIME, amount_claimed NUMBER, amount_settled NUMBER, customer_policy_id NUMBER)
CREATE TABLE customer_policies (policy_id NUMBER, customer_id NUMBER, policy_type_code CLOB, start_date TIME, end_date TIME)
CREATE TABLE claims (claim_id NUMBER, policy_id NUMBER, date_claim_made TIME, date_claim_settled TIME, amount_claimed NUMBER, amount_settled NUMBER)
CREATE TABLE customers (customer_id NUMBER, customer_details CLOB)
CREATE TABLE payments (payment_id NUMBER, settlement_id NUMBER, payment_method_code CLOB, date_payment_made TIME, amount_payment NUMBER)

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" "T1" JOIN "settlements" "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" "T1" JOIN "settlements" "T2" ON "T1"."claim_id" = "T2"."claim_id" WHERE "T1"."amount_claimed" = (SELECT MAX("amount_claimed") FROM "claims")