Database: manufactory_1
Question: What is the total revenue of each manufacturer?
SQL:
SELECT sum(revenue) ,  name FROM manufacturers GROUP BY name