Select the code of each box, along with the name of the city the box is located in.
| SELECT code, warehouse FROM boxes
| SELECT code, location FROM warehouses
| RENAME code warehouse
| JOIN warehouse
| PROJECT code, location
10 rows 0 msec
| SELECT code, location FROM warehouses
| RENAME code warehouse
| JOIN warehouse
| PROJECT code, location
10 rows 0 msec
| code | location |
|---|---|
| 0MN7 | New York |
| 4H8P | Chicago |
| 4RT3 | Los Angeles |
| 7G3H | Chicago |
| 8JN6 | Chicago |
| 8Y6U | New York |
| 9J6F | Chicago |
| LL08 | Los Angeles |
| P0H6 | Chicago |
| P2T6 | Chicago |