Show all the address information.
select * from addresses
Find the names of all the cities.
select town_city from addresses
Find the names of all the cities and states.
select town_city from addresses union select state_province_county from addresses