What is the name of the manufacturer that has the highest revenue?
select name from manufacturers order by revenue desc limit 1
What is the name of the manufacturer that has the third lowest revenue?
select name from manufacturers order by revenue asc limit 2,1
Who is the founder of Creative Labs?
select founder from manufacturers where name = "Creative Labs"
What is the average revenue of all manufacturers?
select avg ( revenue ) from manufacturers
What is the name of the founder of the manufacturer that has the highest revenue?
select founder from manufacturers order by revenue desc limit 1