SELECT avg(price) FROM products WHERE Manufacturer  =  2
Compute the average price of all products with manufacturer code equal to 2.
SELECT avg ( price ) FROM products WHERE Manufacturer = 2
select avg ( price ) from products where manufacturer = value
Compute the average price of all products with manufacturer code equal to 2 .