CREATE TABLE Customers (Customer_ID INT, Customer_name VARCHAR)
CREATE TABLE Claims (Claim_ID INT, FNOL_ID INT, Effective_Date DATE)
CREATE TABLE Services (Service_ID INT, Service_name VARCHAR)
CREATE TABLE Settlements (Settlement_ID INT, Claim_ID INT, Effective_Date DATE, Settlement_Amount FLOAT)
CREATE TABLE First_Notification_of_Loss (FNOL_ID INT, Customer_ID INT, Policy_ID INT, Service_ID INT)
CREATE TABLE Available_Policies (Policy_ID INT, policy_type_code CHAR, Customer_Phone VARCHAR)
CREATE TABLE Customers_Policies (Customer_ID INT, Policy_ID INT, Date_Opened DATE, Date_Closed DATE)

Retrieve the close dates of all the policies associated with the customer whose name contains 'Diana', bin the close dates into the day of week interval and count them for a bar chart.
SELECT Date_Closed, COUNT(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 "Date_Closed", COUNT("Date_Closed") FROM "Customers" AS "t1" JOIN "Customers_Policies" AS "t2" ON "t1"."Customer_ID" = "t2"."Customer_ID" WHERE "t1"."Customer_name" LIKE "%Diana%"