Select the average price of each manufacturer's products, showing the manufacturer's name.
| SELECT manufacturer, price FROM products
| GROUP manufacturer, price AVG BY manufacturer
| SELECT code, name FROM manufacturer
| RENAME code manufacturer
| JOIN manufacturer
| PROJECT name, price-avg
6 rows 0 msec
| GROUP manufacturer, price AVG BY manufacturer
| SELECT code, name FROM manufacturer
| RENAME code manufacturer
| JOIN manufacturer
| PROJECT name, price-avg
6 rows 0 msec
| name | price-avg |
|---|---|
| Sony | 240 |
| Creative Labs | 135 |
| Hewlett Packard | 168 |
| Iomega | 150 |
| Fujitsu | 240 |
| Winchester | 62.5 |