Database: warehouse_1
Question: What is the average value of boxes for each warehouse?
SQL:
SELECT warehouse ,  avg(value) FROM boxes GROUP BY warehouse