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.
SELECT Name, MAX(Revenue) FROM Manufacturers GROUP BY Headquarter
SELECT "Name", MAX("Revenue") FROM "Manufacturers" GROUP BY "Headquarter"