Database: warehouse_1
Question: Find the total, average, and maximum capacity for different locations.
SQL:
SELECT sum(capacity) ,  avg(capacity) ,  max(capacity) ,  LOCATION FROM warehouses GROUP BY LOCATION