Database: address_1
Question: Show names, codes, states, countries for all cities.
SQL:
SELECT city_name ,  city_code ,  state ,  country FROM City