Select the codes of all the boxes located in Chicago.
| SELECT code FROM warehouses WHERE location == Chicago
| RENAME code warehouse
| SELECT code, warehouse FROM boxes WHERE warehouse
| JOIN warehouse
| PROJECT code
6 rows 0 msec
| RENAME code warehouse
| SELECT code, warehouse FROM boxes WHERE warehouse
| JOIN warehouse
| PROJECT code
6 rows 0 msec
| code |
|---|
| 4H8P |
| 7G3H |
| 8JN6 |
| P0H6 |
| 9J6F |
| P2T6 |