What are the names of manufacturers with revenue greater than the average of all revenues?
CREATE TABLE products (
    code number,
    name text,
    price number,
    manufacturer number
)

CREATE TABLE manufacturers (
    code number,
    name text,
    headquarter text,
    founder text,
    revenue number
)
SELECT name FROM manufacturers WHERE revenue > (SELECT AVG(revenue) FROM manufacturers)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the names of manufacturers with revenue greater than the average of all revenues? ### Input: CREATE TABLE products (
    code number,
    name text,
    price number,
    manufacturer number
)

CREATE TABLE manufacturers (
    code number,
    name text,
    headquarter text,
    founder text,
    revenue number
) ### Response: SELECT name FROM manufacturers WHERE revenue > (SELECT AVG(revenue) FROM manufacturers)