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