Select all boxes with a value larger than $150.
| SELECT code, contents, value, warehouse FROM boxes WHERE value > 150
5 rows 0 msec
5 rows 0 msec
| code | contents | value | warehouse |
|---|---|---|---|
| 0MN7 | Rocks | 180 | 3 |
| 4H8P | Rocks | 250 | 1 |
| 4RT3 | Scissors | 190 | 4 |
| 7G3H | Rocks | 200 | 1 |
| 9J6F | Papers | 175 | 2 |