how many companies are there?
select count(*) from manufacturers
What is their average revenue?
select avg(revenue) from manufacturers
Find the names of companies whose revenue is greater than the average.
select name from manufacturers where revenue > (select avg(revenue) from manufacturers)