CREATE TABLE Claims (claim_id VARCHAR2, date_claim_made VARCHAR2, Date_Claim_Settled VARCHAR2, Claim_id VARCHAR2)
CREATE TABLE Settlements (Claim_id VARCHAR2)

List the date the claim was made, the date it was settled and the amount settled for all the claims which had exactly one settlement.
SELECT T1.Claim_id, T1.date_claim_made, T1.Date_Claim_Settled FROM Claims AS T1 JOIN Settlements AS T2 ON T1.Claim_id = T2.Claim_id GROUP BY T1.Claim_id HAVING COUNT(*) = 1
SELECT "T1"."Claim_id", "T1"."date_claim_made", "T1"."Date_Claim_Settled" FROM "Claims" "T1" JOIN "Settlements" "T2" ON "T1"."Claim_id" = "T2"."Claim_id" GROUP BY "T1"."Claim_id" HAVING COUNT(*) = 1