What are the claim type codes in the claim headers?
select claim_type_code from claim_headers
The amounts paid?
select amount_piad from claim_headers
What is the sum of that?
select sum(amount_piad) from claim_headers
Show the average as well.
select sum(amount_piad), avg(amount_piad) from claim_headers