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.
CREATE TABLE customer_policies (
    policy_id number,
    customer_id number,
    policy_type_code text,
    start_date time,
    end_date time
)

CREATE TABLE customers (
    customer_id number,
    customer_details text
)

CREATE TABLE payments (
    payment_id number,
    settlement_id number,
    payment_method_code text,
    date_payment_made time,
    amount_payment number
)

CREATE TABLE claims (
    claim_id number,
    policy_id number,
    date_claim_made time,
    date_claim_settled time,
    amount_claimed number,
    amount_settled number
)

CREATE TABLE settlements (
    settlement_id number,
    claim_id number,
    date_claim_made time,
    date_claim_settled time,
    amount_claimed number,
    amount_settled number,
    customer_policy_id number
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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. ### Input: CREATE TABLE customer_policies (
    policy_id number,
    customer_id number,
    policy_type_code text,
    start_date time,
    end_date time
)

CREATE TABLE customers (
    customer_id number,
    customer_details text
)

CREATE TABLE payments (
    payment_id number,
    settlement_id number,
    payment_method_code text,
    date_payment_made time,
    amount_payment number
)

CREATE TABLE claims (
    claim_id number,
    policy_id number,
    date_claim_made time,
    date_claim_settled time,
    amount_claimed number,
    amount_settled number
)

CREATE TABLE settlements (
    settlement_id number,
    claim_id number,
    date_claim_made time,
    date_claim_settled time,
    amount_claimed number,
    amount_settled number,
    customer_policy_id number
) ### Response: 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