Database: warehouse_1
Question: Select the warehouse codes along with the number of boxes in each warehouse.
SQL:
SELECT Warehouse ,  count(*) FROM boxes GROUP BY warehouse