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
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 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 value
What is the effective date of the claim that has the largest amount of total settlement ?