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

Please tell the revenues of the companies with the highest revenues in each headquarter city, and sort by the y-axis in asc.
SELECT Headquarter, MAX(Revenue) FROM Manufacturers GROUP BY Headquarter ORDER BY MAX(Revenue)
SELECT "Headquarter", MAX("Revenue") FROM "Manufacturers" GROUP BY "Headquarter" ORDER BY MAX("Revenue") NULLS FIRST