CREATE TABLE addresses (town_city VARCHAR, state_province_county VARCHAR)

Find the name of all the cities and states.
SELECT town_city FROM addresses UNION SELECT state_province_county FROM addresses
SELECT "town_city" FROM "addresses" UNION SELECT "state_province_county" FROM "addresses"