SELECT name FROM manufacturers WHERE revenue  >  (SELECT avg(revenue) FROM manufacturers)
Find the name of companies whose revenue is greater than the average revenue of all companies.
SELECT name FROM manufacturers WHERE revenue > ( SELECT avg ( revenue ) FROM manufacturers )
select name from manufacturers where revenue > ( select avg ( revenue ) from manufacturers )
Find the name of companies whose revenue is greater than the average revenue of all companies .