human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the name of the manufacturer that has the highest revenue?
assistant
SELECT name FROM manufacturers ORDER BY revenue DESC LIMIT 1;
human
What is the name of the manufacturer that has the third lowest revenue?
assistant
SELECT name FROM manufacturers ORDER BY revenue asc LIMIT 2 , 1;
human
Who is the founder of Creative Labs?
assistant
SELECT Founder FROM manufacturers WHERE name = 'Creative Labs';
human
What is the average revenue of all manufacturers?
assistant
SELECT AVG ( Revenue ) FROM manufacturers;
human
What is the name of the founder of the manufacturer that has the highest revenue?
assistant
SELECT founder FROM manufacturers ORDER BY revenue DESC LIMIT 1 ;