SELECT name ,  max(revenue) ,  Headquarter FROM manufacturers GROUP BY Headquarter
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
select name , max ( revenue ) , headquarter from manufacturers group by headquarter
What are the names and revenues of the companies with the highest revenues in each headquarter city ?