Select the warehouse code and the average value of the boxes in each warehouse.
| SELECT warehouse, value FROM boxes
| GROUP warehouse, value AVG BY warehouse
| WHERE value-avg > 150
3 rows 0 msec
| GROUP warehouse, value AVG BY warehouse
| WHERE value-avg > 150
3 rows 0 msec
| warehouse | value-avg |
|---|---|
| 1 | 162.5 |
| 2 | 162.5 |
| 4 | 165 |