Database: manufactory_1
Question: Find the name of companies whose revenue is greater than the average revenue of all companies.
SQL:
SELECT name FROM manufacturers WHERE revenue  >  (SELECT avg(revenue) FROM manufacturers)