Database: address_1
Question: Show all states and number of cities in each state.
SQL:
SELECT state ,  count(*) FROM City GROUP BY state