Database: warehouse_1
Question: What is the total value of boxes located in Chicago or New York?
SQL:
SELECT sum(T1.value) FROM boxes AS T1 JOIN warehouses AS T2 ON T1.warehouse  =  T2.code WHERE T2.location  =  'Chicago' OR T2.location  =  'New York'