Schema: CREATE TABLE manufacturers (founder VARCHAR, revenue INTEGER)
Question: Find the total revenue of companies of each founder.
SQL: SELECT SUM(revenue), founder FROM manufacturers GROUP BY founder