<question>: Find the name and revenue of the company that earns the highest revenue in each city. <context>: CREATE TABLE manufacturers (name VARCHAR, Headquarter VARCHAR, revenue INTEGER)
SELECT name, MAX(revenue), Headquarter FROM manufacturers GROUP BY Headquarter