CREATE TABLE Products (product_id NUMBER, product_type_code VARCHAR2, product_name VARCHAR2, product_price DOUBLE PRECISION)
CREATE TABLE Order_Items (order_item_id NUMBER, order_id NUMBER, product_id NUMBER, order_quantity VARCHAR2)
CREATE TABLE Customer_Orders (order_id NUMBER, customer_id NUMBER, order_date DATETIME, order_status_code VARCHAR2)
CREATE TABLE Contacts (contact_id NUMBER, customer_id NUMBER, gender VARCHAR2, first_name VARCHAR2, last_name VARCHAR2, contact_phone VARCHAR2)
CREATE TABLE Addresses (address_id NUMBER, line_1_number_building VARCHAR2, city VARCHAR2, zip_postcode VARCHAR2, state_province_county VARCHAR2, country VARCHAR2)
CREATE TABLE Customers (customer_id NUMBER, payment_method_code VARCHAR2, customer_number VARCHAR2, customer_name VARCHAR2, customer_address VARCHAR2, customer_phone VARCHAR2, customer_email VARCHAR2)
CREATE TABLE Customer_Address_History (customer_id NUMBER, address_id NUMBER, date_from DATETIME, date_to DATETIME)

Show each state and the number of addresses in each state Show bar chart, and sort y-axis in desc order.
SELECT state_province_county, COUNT(*) FROM Addresses GROUP BY state_province_county ORDER BY COUNT(*) DESC
SELECT "state_province_county", COUNT(*) FROM "Addresses" GROUP BY "state_province_county" ORDER BY COUNT(*) DESC