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

Create a bar chart showing maximal revenue across headquarter
SELECT Headquarter, MAX(Revenue) FROM Manufacturers GROUP BY Headquarter
SELECT "Headquarter", MAX("Revenue") FROM "Manufacturers" GROUP BY "Headquarter"