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

Please tell the names and revenues of the companies with the highest revenues in each headquarter city, and display from low to high by the maximal revenue.
SELECT Name, MAX(Revenue) FROM Manufacturers GROUP BY Headquarter ORDER BY MAX(Revenue)
SELECT "Name", MAX("Revenue") FROM "Manufacturers" GROUP BY "Headquarter" ORDER BY MAX("Revenue")