SELECT sum(revenue) ,  name FROM manufacturers GROUP BY name
What is the total revenue of each manufacturer?
SELECT sum ( revenue ) , name FROM manufacturers GROUP BY name
select sum ( revenue ) , name from manufacturers group by name
What is the total revenue of each manufacturer ?