CREATE TABLE products (code NUMBER, name CLOB, price NUMBER, manufacturer NUMBER)
CREATE TABLE manufacturers (code NUMBER, name CLOB, headquarter CLOB, founder CLOB, revenue NUMBER)

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