Table schema:
CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER)

Question: Find the total revenue for each manufacturer.
SQL: SELECT SUM(revenue), name FROM manufacturers GROUP BY name