Database: manufactory_1
Question: Find the total revenue of companies of each founder.
SQL:
SELECT sum(revenue) ,  founder FROM manufacturers GROUP BY founder