Claim number 801 had 4 settlements, what was the largest one? | Do you mean largest in terms of the amount claimed or amount settled? | Yes, both.
SELECT T2.settlement_id,T2.amount_claimed,T2.amount_settled FROM Claims AS T1 JOIN Settlements AS T2 ON T1.claim_id   =   T2.claim_id where T1.claim_id = 801
largest in terms of amount refers to MAX(amount); claim number refers to claim_id; settlements refers to records in Settlements table; both amount claimed and amount settled refers to fields amount_claimed and amount_settled respectively;