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

Show each state and the number of addresses in each state by a bar chart, and sort total number 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 NULLS LAST