Database: warehouse_1
Question: Select the warehouse code and the average value of the boxes in each warehouse.
SQL:
SELECT warehouse ,  avg(value) FROM boxes GROUP BY warehouse