Database: manufactory_1
Question: Find the total revenue for each manufacturer.
SQL:
SELECT sum(revenue) ,  name FROM manufacturers GROUP BY name