Select the name of each manufacturer along with the name and price of its most expensive product.
| SELECT price, manufacturer FROM products
| GROUP manufacturer, price MAX BY manufacturer
| SELECT code, name FROM manufacturer
| RENAME code manufacturer
| JOIN manufacturer
| PROJECT name, price-max
6 rows 1 msec
| GROUP manufacturer, price MAX BY manufacturer
| SELECT code, name FROM manufacturer
| RENAME code manufacturer
| JOIN manufacturer
| PROJECT name, price-max
6 rows 1 msec
| name | price-max |
|---|---|
| Sony | 240 |
| Creative Labs | 180 |
| Hewlett Packard | 270 |
| Iomega | 150 |
| Fujitsu | 240 |
| Winchester | 120 |