Database: warehouse_1
Question: Find the total values of boxes that are not in the warehouses located at Chicago.
SQL:
SELECT sum(T1.value) FROM boxes AS T1 JOIN Warehouses AS T2 ON T1.warehouse  =  T2.code WHERE T2.location != 'Chicago'