What are the names and average prices of products for manufacturers whose products cost on average 150 or more?
select avg(t1.price), t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code group by t2.name having avg(t1.price) >= 150