Database: insurance_fnol
Question: What are the open and close dates of all the policies used by the customer who have "Diana" in part of their names?
SQL:
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%"