The Computer Store exercise 6

Back to The Computer Store

Compute the average price of all products with manufacturer code equal to 2.

| SELECT price FROM products WHERE manufacturer = 2
| GROUP price AVG
1 row 0 msec
price-avg
135