CREATE TABLE Products (Code NUMBER, Name VARCHAR2, Price NUMBER, Manufacturer NUMBER)
CREATE TABLE Manufacturers (Code NUMBER, Name VARCHAR2, Headquarter VARCHAR2, Founder VARCHAR2, Revenue FLOAT)

What is the total revenue of each manufacturer.
SELECT Name, SUM(Revenue) FROM Manufacturers GROUP BY Name
SELECT "Name", SUM("Revenue") FROM "Manufacturers" GROUP BY "Name"