Encontre o nome de todas as cidades e estados.
CREATE TABLE addresses (town_city VARCHAR, state_province_county VARCHAR)
SELECT town_city FROM addresses UNION SELECT state_province_county FROM addresses