Database: warehouse_1
Question: Find the total value of boxes in the warehouses located at 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'