Database: warehouse_1
Question: For each warehouse location, what is the value of the most expensive box?
SQL:
SELECT max(T1.value) ,  T2.location FROM boxes AS T1 JOIN warehouses AS T2 ON T1.warehouse  =  T2.code GROUP BY T2.location