Show the state for each address.
select state_province_county from addresses
Also show the number of addresses in each of them.
select state_province_county, count(*) from addresses group by state_province_county