find the name of products with a price higher than or equal to $150.
select name from products where price >= 150
what are the names of manufacturers that produce these products?
select distinct t2.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code where t1.price >= 150
Select the names of manufacturer whose products have an average price higher than or equal to $150.
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