What is the name of the customer who has made the minimum amount of payment in one claim?
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_piad = ( select min ( amount_piad ) from claim_headers )
What is the amount claimed for this customer?
select t1.amount_claimed 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_piad = ( select min ( amount_piad ) from claim_headers )
Can you also give me  the name of the customer who has made the maximum amount of payment in one claim?
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_piad = ( select max ( amount_piad ) from claim_headers )
Hmmm. Can you please give me the claimed amount for this customer
select t1.amount_claimed 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_piad = ( select max ( amount_piad ) from claim_headers )