Find the total revenue for each manufacturer.
CREATE TABLE manufacturers (
    name VARCHAR,
    revenue INTEGER
)
SELECT SUM(revenue), name FROM manufacturers GROUP BY name
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: Find the total revenue for each manufacturer. ### Input: CREATE TABLE manufacturers (
    name VARCHAR,
    revenue INTEGER
) ### Response: SELECT SUM(revenue), name FROM manufacturers GROUP BY name