CREATE TABLE manufacturers (name VARCHAR2, revenue NUMBER)

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")