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
Her bir merkez şehrinde en yüksek gelirlere sahip şirketlerin isimleri ve gelirleri nelerdir?