Find the name of all the cities and states. | you want the columns of town_city and state_province_county,right? | Umm. Give me the names and the states please
SELECT town_city FROM addresses UNION SELECT state_province_county FROM addresses
name of all the cities refers to town_city; states refers to state_province_county; UNION is used to combine the results of two SELECT queries.