CREATE TABLE customers_policies (customer_id NUMBER, policy_id NUMBER, date_opened TIME, date_closed TIME)
CREATE TABLE customers (customer_id NUMBER, customer_name CLOB)
CREATE TABLE services (service_id NUMBER, service_name CLOB)
CREATE TABLE available_policies (policy_id NUMBER, policy_type_code CLOB, customer_phone CLOB)
CREATE TABLE claims (claim_id NUMBER, fnol_id NUMBER, effective_date TIME)
CREATE TABLE settlements (settlement_id NUMBER, claim_id NUMBER, effective_date TIME, settlement_amount NUMBER)
CREATE TABLE first_notification_of_loss (fnol_id NUMBER, customer_id NUMBER, policy_id NUMBER, service_id NUMBER)

What is the effective date of the claim that has the largest amount of total settlement?
SELECT t1.effective_date FROM claims AS t1 JOIN settlements AS t2 ON t1.claim_id = t2.claim_id GROUP BY t1.claim_id ORDER BY SUM(t2.settlement_amount) DESC LIMIT 1
SELECT "t1"."effective_date" FROM "claims" "t1" JOIN "settlements" "t2" ON "t1"."claim_id" = "t2"."claim_id" GROUP BY "t1"."claim_id" ORDER BY SUM("t2"."settlement_amount") DESC FETCH FIRST 1 ROWS ONLY