Obtain the names of all providers who supply piece 1.
| VERBOSE
| SELECT provider FROM provides WHERE piece = 1
| SELECT name, code WHERE code
| RENAME code provider
| JOIN provider
| PROJECT name
2 rows 0 msec
| SELECT provider FROM provides WHERE piece = 1
| SELECT name, code WHERE code
| RENAME code provider
| JOIN provider
| PROJECT name
2 rows 0 msec
| name |
|---|
| Clarke Entreprises |
| Susan Calvin Corp. |