SELECT sum(revenue) ,  name FROM manufacturers GROUP BY name
Find the total revenue for each manufacturer.
SELECT sum ( revenue ) , name FROM manufacturers GROUP BY name
select sum ( revenue ) , name from manufacturers group by name
Find the total revenue for each manufacturer .