what is the average price among all products?
select avg ( price ) from products
which products have a price higher than or equal to $150?
select * from products where price > = 150
what are the names of the manufacturers of those products?
select t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code where t1.price > = 150