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

Find the claims that led to more than two settlements or have the maximum claim value. For each of them, return the date the claim was made and the id of the claim.
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(*) > 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")