Show each state and the number of addresses in each state.
create table addresses (state_province_county varchar, PRIMARY KEY (state_province_county))
select state_province_county, count(*) from addresses group by state_province_county