Retrieve the open and close dates of all the policies associated with the customer whose name contains 'Diana
CREATE TABLE settlements (
    settlement_id number,
    claim_id number,
    effective_date time,
    settlement_amount number
)

CREATE TABLE services (
    service_id number,
    service_name text
)

CREATE TABLE available_policies (
    policy_id number,
    policy_type_code text,
    customer_phone text
)

CREATE TABLE customers (
    customer_id number,
    customer_name text
)

CREATE TABLE claims (
    claim_id number,
    fnol_id number,
    effective_date time
)

CREATE TABLE customers_policies (
    customer_id number,
    policy_id number,
    date_opened time,
    date_closed time
)

CREATE TABLE first_notification_of_loss (
    fnol_id number,
    customer_id number,
    policy_id number,
    service_id number
)
SELECT t2.date_opened, t2.date_closed FROM customers AS t1 JOIN customers_policies AS t2 ON t1.customer_id = t2.customer_id WHERE t1.customer_name LIKE "%Diana%"
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: Retrieve the open and close dates of all the policies associated with the customer whose name contains 'Diana ### Input: CREATE TABLE settlements (
    settlement_id number,
    claim_id number,
    effective_date time,
    settlement_amount number
)

CREATE TABLE services (
    service_id number,
    service_name text
)

CREATE TABLE available_policies (
    policy_id number,
    policy_type_code text,
    customer_phone text
)

CREATE TABLE customers (
    customer_id number,
    customer_name text
)

CREATE TABLE claims (
    claim_id number,
    fnol_id number,
    effective_date time
)

CREATE TABLE customers_policies (
    customer_id number,
    policy_id number,
    date_opened time,
    date_closed time
)

CREATE TABLE first_notification_of_loss (
    fnol_id number,
    customer_id number,
    policy_id number,
    service_id number
) ### Response: SELECT t2.date_opened, t2.date_closed FROM customers AS t1 JOIN customers_policies AS t2 ON t1.customer_id = t2.customer_id WHERE t1.customer_name LIKE "%Diana%"