What are the names and revenues of the companies with the highest revenues in each headquarter city?
select name, max(revenue), headquarter from manufacturers group by headquarter