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 ) 
name of the customer who has made the maximum amount of payment in one claim refers to SELECT ... FROM customers WHERE claim amount = MAX(amount_paid);