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