SELECT name FROM manufacturers WHERE revenue  >  (SELECT avg(revenue) FROM manufacturers)
What are the names of manufacturers with revenue greater than the average of all revenues?
SELECT name FROM manufacturers WHERE revenue > ( SELECT avg ( revenue ) FROM manufacturers )
select name from manufacturers where revenue > ( select avg ( revenue ) from manufacturers )
What are the names of manufacturers with revenue greater than the average of all revenues ?