Database: warehouse_1
Question: How many boxes are there with each warehouse ?
SQL:
select warehouse ,  count(*) from boxes group by warehouse