Find the name and revenue of the company that earns the highest revenue in each city.
select name, max(revenue), headquarter from manufacturers group by headquarter