Database: warehouse_1
Question: Select the warehouse code and the average value of the boxes only for those warehouses where the average value of the boxes is greater than 150.
SQL:
SELECT warehouse ,  avg(value) FROM boxes GROUP BY warehouse HAVING avg(value)  >  150