Find the total revenue of companies of each founder.
CREATE TABLE manufacturers (founder VARCHAR, revenue INTEGER)
SELECT SUM(revenue), founder FROM manufacturers GROUP BY founder
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE manufacturers (founder VARCHAR, revenue INTEGER) Question: Find the total revenue of companies of each founder. [/INST] SELECT SUM(revenue), founder FROM manufacturers GROUP BY founder </s>