CREATE TABLE manufacturers (founder VARCHAR2, revenue NUMBER)

Find the total revenue of companies of each founder.
SELECT SUM(revenue), founder FROM manufacturers GROUP BY founder
SELECT SUM("revenue"), "founder" FROM "manufacturers" GROUP BY "founder"