Database: warehouse_1
Question: Select the code of each box, along with the name of the city the box is located in.
SQL:
SELECT T1.code ,  T2.location FROM boxes AS T1 JOIN warehouses AS T2 ON T1.Warehouse  =  T2.Code