What was the smallest policy amount paid?
select min(amount_piad) from claim_headers
Claim amount instead?
select min(amount_claimed) from claim_headers
Which was the policy for this?
select * from claim_headers as t1 join policies as t2 on t1.policy_id = t2.policy_id where t1.amount_claimed = (select min(amount_claimed) from claim_headers)
For the largest claim amount instead?
select * from claim_headers as t1 join policies as t2 on t1.policy_id = t2.policy_id where t1.amount_claimed = (select max(amount_claimed) from claim_headers)
Which customer owns this policy?
select t3.customer_details from claim_headers as t1 join policies as t2 on t1.policy_id = t2.policy_id join customers as t3 on t2.customer_id = t3.customer_id where t1.amount_claimed = (select max(amount_claimed) from claim_headers)