Select the name of pieces provided by provider with code "HAL".
| SELECT piece FROM provides WHERE provider == HAL
| SELECT name, code FROM piece WHERE code
| RENAME code piece
| JOIN piece
| PROJECT name
3 rows 0 msec
| SELECT name, code FROM piece WHERE code
| RENAME code piece
| JOIN piece
| PROJECT name
3 rows 0 msec
| name |
|---|
| Sprocket |
| Screw |
| Bolt |