human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
Yes. Can you please provide the name in alphabetical order?
assistant
SELECT name FROM products WHERE price > = 180 ORDER by name ASC;
human
Thank you. Can you please provide the price of each of these items as well sorted by lowest price first?
assistant
SELECT name , price FROM products WHERE price > = 180 ORDER by price asc;
human
Can you please also provide the manufacturer on these products?
assistant
SELECT name , price , manufacturer FROM products WHERE price > = 180 ORDER by price asc ;