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

Create a bar chart showing maximal revenue across headquarter, rank in desc by the bars.
SELECT Headquarter, MAX(Revenue) FROM Manufacturers GROUP BY Headquarter ORDER BY Headquarter DESC
SELECT "Headquarter", MAX("Revenue") FROM "Manufacturers" GROUP BY "Headquarter" ORDER BY "Headquarter" DESC NULLS LAST