Database: warehouse_1
Question: How many boxes are stored in each warehouse?
SQL:
SELECT count(*) ,  warehouse FROM boxes GROUP BY warehouse