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 the company that earned the least revenue.
assistant
SELECT name FROM manufacturers ORDER BY revenue LIMIT 1;
human
show its headquarter location and founder too.
assistant
SELECT name , headquarter , founder FROM manufacturers ORDER BY revenue LIMIT 1;
human
what is the info for the company with the highest revenue?
assistant
SELECT name , headquarter , founder FROM manufacturers ORDER BY revenue DESC LIMIT 1 ;