text: CREATE TABLE first_notification_of_loss (customer_id VARCHAR, service_id VARCHAR); CREATE TABLE customers (customer_name VARCHAR, customer_id VARCHAR); CREATE TABLE services (service_id VARCHAR, service_name VARCHAR) -- Find the names of customers who have used both the service "Close a policy" and the service "New policy application". SELECT t1.customer_name FROM customers AS t1 JOIN first_notification_of_loss AS t2 ON t1.customer_id = t2.customer_id JOIN services AS t3 ON t2.service_id = t3.service_id WHERE t3.service_name = "Close a policy" INTERSECT SELECT t1.customer_name FROM customers AS t1 JOIN first_notification_of_loss AS t2 ON t1.customer_id = t2.customer_id JOIN services AS t3 ON t2.service_id = t3.service_id WHERE t3.service_name = "New policy application" CREATE TABLE customers (customer_id VARCHAR, customer_name VARCHAR) -- Find the IDs of customers whose name contains "Diana". SELECT customer_id FROM customers WHERE customer_name LIKE "%Diana%" CREATE TABLE settlements (settlement_amount INTEGER) -- What are the maximum and minimum settlement amount on record? SELECT MAX(settlement_amount), MIN(settlement_amount) FROM settlements CREATE TABLE customers (customer_id VARCHAR, customer_name VARCHAR) -- List all the customers in increasing order of IDs. SELECT customer_id, customer_name FROM customers ORDER BY customer_id CREATE TABLE customers (customer_id VARCHAR, customer_name VARCHAR); CREATE TABLE customers_policies (date_opened VARCHAR, date_closed VARCHAR, customer_id VARCHAR) -- 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%"