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
Find the claim that has the largest total settlement amount. Return the effective date of the claim.
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
Find the claim that has the largest total settlement amount . Return the effective date of the claim .