SELECT state_province_county ,  count(*) FROM addresses GROUP BY state_province_county
Show each state and the number of addresses in each state.
SELECT state_province_county , count ( * ) FROM addresses GROUP BY state_province_county
select state_province_county , count ( * ) from addresses group by state_province_county
Show each state and the number of addresses in each state .