Database: warehouse_1
Question: What are the codes of boxes stored in warehouses in either Chicago or New York?
SQL:
SELECT T1.code FROM boxes AS T1 JOIN warehouses AS T2 ON T1.warehouse  =  T2.code WHERE T2.location  =  'Chicago' OR T2.location  =  'New York'