Find the total revenue for each manufacturer.
CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER)
SELECT SUM(revenue), name FROM manufacturers GROUP BY name
### Context: CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER) ### Question: Find the total revenue for each manufacturer. ### Answer: SELECT SUM(revenue), name FROM manufacturers GROUP BY name