Database: manufactory_1
Question: What are the names of manufacturers with revenue greater than the average of all revenues?
SQL:
SELECT name FROM manufacturers WHERE revenue  >  (SELECT avg(revenue) FROM manufacturers)