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%"
Retrieve the open and close dates of all the policies associated with the customer whose name contains "Diana"
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 % ''
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 value
Retrieve the open and close dates of all the policies associated with the customer whose name contains `` Diana ''