Database: address_1
Question: How many cities are in each state?
SQL:
SELECT state ,  count(*) FROM City GROUP BY state