Database: address_1
Question: What are the names, codes, states, and countries for all cities?
SQL:
SELECT city_name ,  city_code ,  state ,  country FROM City