Database: warehouse_1
Question: For each location, what are the total, average, and maximum capacities of warehouses?
SQL:
SELECT sum(capacity) ,  avg(capacity) ,  max(capacity) ,  LOCATION FROM warehouses GROUP BY LOCATION