Table schema:
CREATE TABLE manufacturers (name VARCHAR, Headquarter VARCHAR, revenue INTEGER)

Question: Find the name and revenue of the company that earns the highest revenue in each city.
SQL: SELECT name, MAX(revenue), Headquarter FROM manufacturers GROUP BY Headquarter