Show each state and the number of addresses in each state.
CREATE TABLE addresses (state_province_county VARCHAR)
SELECT state_province_county, COUNT(*) FROM addresses GROUP BY state_province_county
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE addresses (state_province_county VARCHAR) Question: Show each state and the number of addresses in each state. [/INST] SELECT state_province_county, COUNT(*) FROM addresses GROUP BY state_province_county </s>