CREATE TABLE Addresses (address_id INT, address_content VARCHAR, city VARCHAR, zip_postcode VARCHAR, state_province_county VARCHAR, country VARCHAR, other_address_details VARCHAR)
CREATE TABLE Order_Items (order_id INT, product_id INT, order_quantity VARCHAR)
CREATE TABLE Customer_Orders (order_id INT, customer_id INT, order_status VARCHAR, order_date DATETIME, order_details VARCHAR)
CREATE TABLE Customer_Contact_Channels (customer_id INT, channel_code VARCHAR, active_from_date DATETIME, active_to_date DATETIME, contact_number VARCHAR)
CREATE TABLE Products (product_id INT, product_details VARCHAR)
CREATE TABLE Customer_Addresses (customer_id INT, address_id INT, date_address_from DATETIME, address_type VARCHAR, date_address_to DATETIME)
CREATE TABLE Customers (customer_id INT, payment_method VARCHAR, customer_name VARCHAR, date_became_customer DATETIME, other_customer_details VARCHAR)

What is the number of orders that have the status 'Delivered' for each customer name? Visualize in a bar chart.
SELECT customer_name, COUNT(customer_name) FROM Customers AS t1 JOIN Customer_Orders AS t2 ON t1.customer_id = t2.customer_id WHERE order_status = "Delivered" GROUP BY customer_name
SELECT "customer_name", COUNT("customer_name") FROM "Customers" AS "t1" JOIN "Customer_Orders" AS "t2" ON "t1"."customer_id" = "t2"."customer_id" WHERE "Delivered" = "order_status" GROUP BY "customer_name"