Umm. Give me the names and the states please
select town_city from addresses union select state_province_county from addresses
Can you give me the zip_postcode for Colorado
select zip_postcode from addresses where state_province_county = 'Colorado'
Give me the cities where the state is Colorado
select town_city from addresses where state_province_county = 'Colorado'
Ok. Can you give me the cities where the state is NorthCarolina
select town_city from addresses where state_province_county = 'NorthCarolina'
Give me all the zipcodes
select zip_postcode from addresses