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