Find the name and revenue of the company that earns the highest revenue in each city.
CREATE TABLE manufacturers (name VARCHAR, Headquarter VARCHAR, revenue INTEGER)
[SQL] SELECT name, MAX(revenue), Headquarter FROM manufacturers GROUP BY Headquarter [/SQL]