What are the names, headquarters and revenues for manufacturers, sorted by revenue descending?
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, headquarter, revenue FROM manufacturers ORDER BY revenue DESC
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, headquarters and revenues for manufacturers, sorted by revenue descending? ### 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, headquarter, revenue FROM manufacturers ORDER BY revenue DESC