Among all the claims, which one has the largest claim amount?
select claim_id from claims order by amount_settled asc limit 1
Which one has the least claim amount?
select claim_id from claims order by amount_settled desc limit 1
Which claims have a claimed amount larger than the average? Tell me the date the claim was made and the date it was settled.
select date_claim_made, date_claim_settled from claims where amount_claimed > ( select avg(amount_claimed) from claims )