CREATE TABLE customer_policies (policy_id NUMBER, customer_id NUMBER, policy_type_code CLOB, start_date TIME, end_date TIME)
CREATE TABLE customers (customer_id NUMBER, customer_details CLOB)
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 claims (claim_id NUMBER, policy_id NUMBER, date_claim_made TIME, date_claim_settled TIME, amount_claimed NUMBER, amount_settled NUMBER)
CREATE TABLE payments (payment_id NUMBER, settlement_id NUMBER, payment_method_code CLOB, date_payment_made TIME, amount_payment NUMBER)

Give me the claim date, settlement date for all the claims whose claimed amount is larger than the average.
SELECT date_claim_made, date_claim_settled FROM claims WHERE amount_claimed > (SELECT AVG(amount_claimed) FROM claims)
SELECT "date_claim_made", "date_claim_settled" FROM "claims" WHERE "amount_claimed" > (SELECT AVG("amount_claimed") FROM "claims")