CREATE TABLE Customers (customer_id NUMBER, payment_method VARCHAR2, customer_name VARCHAR2, customer_phone VARCHAR2, customer_email VARCHAR2, date_became_customer DATETIME)
CREATE TABLE Employees (employee_id NUMBER, employee_address_id NUMBER, employee_name VARCHAR2, employee_phone VARCHAR2)
CREATE TABLE Trucks (truck_id NUMBER, truck_licence_number VARCHAR2, truck_details VARCHAR2)
CREATE TABLE Products (product_id NUMBER, product_name VARCHAR2, product_price NUMBER, product_description VARCHAR2)
CREATE TABLE Customer_Addresses (customer_id NUMBER, address_id NUMBER, date_from DATETIME, address_type VARCHAR2, date_to DATETIME)
CREATE TABLE Delivery_Routes (route_id NUMBER, route_name VARCHAR2, other_route_details VARCHAR2)
CREATE TABLE Actual_Orders (actual_order_id NUMBER, order_status_code VARCHAR2, regular_order_id NUMBER, actual_order_date DATETIME)
CREATE TABLE Order_Deliveries (location_code VARCHAR2, actual_order_id NUMBER, delivery_status_code VARCHAR2, driver_employee_id NUMBER, truck_id NUMBER, delivery_date DATETIME)
CREATE TABLE Regular_Orders (regular_order_id NUMBER, distributer_id NUMBER)
CREATE TABLE Actual_Order_Products (actual_order_id NUMBER, product_id NUMBER)
CREATE TABLE Addresses (address_id NUMBER, address_details VARCHAR2, city VARCHAR2, zip_postcode VARCHAR2, state_province_county VARCHAR2, country VARCHAR2)
CREATE TABLE Regular_Order_Products (regular_order_id NUMBER, product_id NUMBER)
CREATE TABLE Delivery_Route_Locations (location_code VARCHAR2, route_id NUMBER, location_address_id NUMBER, location_name VARCHAR2)

List the state names and the number of customers living in each state with a bar chart, order in descending by the Y.
SELECT state_province_county, COUNT(*) FROM Customer_Addresses AS t1 JOIN Addresses AS t2 ON t1.address_id = t2.address_id GROUP BY t2.state_province_county ORDER BY COUNT(*) DESC
SELECT "state_province_county", COUNT(*) FROM "Customer_Addresses" "t1" JOIN "Addresses" "t2" ON "t1"."address_id" = "t2"."address_id" GROUP BY "t2"."state_province_county" ORDER BY COUNT(*) DESC