CREATE TABLE manufacturers (name VARCHAR2, revenue NUMBER)

Find the total revenue for each manufacturer.
SELECT SUM(revenue), name FROM manufacturers GROUP BY name
SELECT SUM("revenue"), "name" FROM "manufacturers" GROUP BY "name"