CREATE TABLE Products (Code INT, Name VARCHAR, Price DECIMAL, Manufacturer INT)
CREATE TABLE Manufacturers (Code INT, Name VARCHAR, Headquarter VARCHAR, Founder VARCHAR, Revenue FLOAT)

Find the total revenue for each manufacturer. Plot them as bar chart.
SELECT Name, SUM(Revenue) FROM Manufacturers GROUP BY Name
SELECT "Name", SUM("Revenue") FROM "Manufacturers" GROUP BY "Name"