CREATE TABLE products (code NUMBER, name CLOB, price NUMBER, manufacturer NUMBER)
CREATE TABLE manufacturers (code NUMBER, name CLOB, headquarter CLOB, founder CLOB, revenue NUMBER)

What is the total revenue of companies started by founder?
SELECT SUM(revenue), founder FROM manufacturers GROUP BY founder
SELECT SUM("revenue"), "founder" FROM "manufacturers" GROUP BY "founder"