Select the average price of each manufacturer's products, showing only the manufacturer's code.
| SELECT manufacturer, price FROM products
| GROUP manufacturer, price AVG BY manufacturer
6 rows 0 msec
| GROUP manufacturer, price AVG BY manufacturer
6 rows 0 msec
| manufacturer | price-avg |
|---|---|
| 1 | 240 |
| 2 | 135 |
| 3 | 168 |
| 4 | 150 |
| 5 | 240 |
| 6 | 62.5 |