Select all boxes with a value larger than $150.
| SELECT code, contents, value, warehouse FROM boxes WHERE value > 150
5 rows 1 msec
5 rows 1 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 |