Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE Regular_Orders ( regular_order_id INTEGER, distributer_id INTEGER )
TABLE: CREATE TABLE Order_Deliveries ( location_code VARCHAR(10), actual_order_id INTEGER, delivery_status_code VARCHAR(10), driver_employee_id INTEGER, truck_id INTEGER, delivery_date DATETIME )
TABLE: CREATE TABLE Customers ( customer_id INTEGER, payment_method VARCHAR(10), customer_name VARCHAR(80), customer_phone VARCHAR(80), customer_email VARCHAR(80), date_became_customer DATETIME )
TABLE: CREATE TABLE Products ( product_id INTEGER, product_name VARCHAR(20), product_price DECIMAL(19,4), product_description VARCHAR(255) )
TABLE: CREATE TABLE Addresses ( address_id INTEGER, address_details VARCHAR(80), city VARCHAR(50), zip_postcode VARCHAR(20), state_province_county VARCHAR(50), country VARCHAR(50) )
TABLE: CREATE TABLE Trucks ( truck_id INTEGER, truck_licence_number VARCHAR(20), truck_details VARCHAR(255) )
TABLE: CREATE TABLE Delivery_Route_Locations ( location_code VARCHAR(10), route_id INTEGER, location_address_id INTEGER, location_name VARCHAR(50) )
TABLE: CREATE TABLE Actual_Order_Products ( actual_order_id INTEGER, product_id INTEGER )
TABLE: CREATE TABLE Customer_Addresses ( customer_id INTEGER, address_id INTEGER, date_from DATETIME, address_type VARCHAR(10), date_to DATETIME )
TABLE: CREATE TABLE Employees ( employee_id INTEGER, employee_address_id INTEGER, employee_name VARCHAR(80), employee_phone VARCHAR(80) )
TABLE: CREATE TABLE Regular_Order_Products ( regular_order_id INTEGER, product_id INTEGER )
TABLE: CREATE TABLE Delivery_Routes ( route_id INTEGER, route_name VARCHAR(50), other_route_details VARCHAR(255) )
TABLE: CREATE TABLE Actual_Orders ( actual_order_id INTEGER, order_status_code VARCHAR(10), regular_order_id INTEGER, actual_order_date DATETIME )

### Question ###
List the state names and the number of customers living in each state, rank by the names in descending.

### Accurate SQL ###

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 state_province_county DESC