human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
find the name of products with a price higher than or equal to $150.
assistant
SELECT name FROM products WHERE price >= 150;
human
what are the names of manufacturers that produce these products?
assistant
SELECT DISTINCT T2.name FROM products AS T1 JOIN Manufacturers AS T2 ON T1.manufacturer = T2.code WHERE T1.price >= 150 ;