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
Her şehirdeki en yüksek geliri kazanan şirketin adını ve gelirini bulun.