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

Give me a bar chart to show the names and revenue of the company that earns the highest revenue in each headquarter city, could you display from low to high by the X please?
SELECT Name, MAX(Revenue) FROM Manufacturers GROUP BY Headquarter ORDER BY Name
SELECT "Name", MAX("Revenue") FROM "Manufacturers" GROUP BY "Headquarter" ORDER BY "Name" NULLS FIRST