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