CREATE TABLE products (code NUMBER, name CLOB, price NUMBER, manufacturer NUMBER)
CREATE TABLE manufacturers (code NUMBER, name CLOB, headquarter CLOB, founder CLOB, 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")