Could you please tell me the total amount paid in claim headers?
select sum ( amount_piad ) from claim_headers
Could you please tell me the average amount paid in claim headers?
select avg ( amount_piad ) from claim_headers
Could you please tell me the total amount claimed?
select sum ( amount_claimed ) from claim_headers
What is the date of the largest amount claimed?
select date_of_claim from claim_headers order by amount_claimed desc limit 1
What is the date of the smallest amount paid?
select date_of_claim from claim_headers order by amount_claimed limit 1