CREATE TABLE manufacturers (name VARCHAR(255), revenue INTEGER)
Find the total revenue for each manufacturer.
    
SQL: SELECT SUM(revenue), name FROM manufacturers GROUP BY name