Average Days to Settle

Return the average number of days between filing and settlement for settled claims, rounded to 2 decimals.

Table schema

Claims(id INT PRIMARY KEY, policy_id INT, amount INT, status VARCHAR(10), filed_on DATE, settled_on DATE)

Sample data

id | policy_id | amount | status | filed_on | settled_on
1 | 101 | 5000 | approved | 2026-01-01 | 2026-01-11
2 | 101 | 2000 | rejected | 2026-02-01 | NULL
3 | 102 | 8000 | approved | 2026-01-15 | 2026-02-04
4 | 103 | 1000 | approved | 2026-03-01 | 2026-03-06
5 | 102 | 3000 | pending | 2026-03-10 | NULL
6 | 101 | 7000 | approved | 2026-03-20 | 2026-04-01