Database: customer_deliveries
Question: List the state names and the number of customers living in each state.
SQL:
SELECT t2.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