Select the names of manufacturer whose products have an average price larger than or equal to $150.
| SELECT manufacturer, price FROM products
| GROUP manufacturer, price AVG BY manufacturer
| SELECT code, name FROM manufacturer
| RENAME code manufacturer
| JOIN manufacturer
| WHERE price-avg >= 150
| PROJECT name
4 rows 0 msec
| GROUP manufacturer, price AVG BY manufacturer
| SELECT code, name FROM manufacturer
| RENAME code manufacturer
| JOIN manufacturer
| WHERE price-avg >= 150
| PROJECT name
4 rows 0 msec
| name |
|---|
| Sony |
| Hewlett Packard |
| Iomega |
| Fujitsu |
Use The Computer Store exercise 11 as starting point. The advantage of the stack system with the query function is that you have at any step a table you can further work on. Here you refine with the condition on the average price.