Database: manufactory_1
Question: What are the names and revenues of the companies with the highest revenues in each headquarter city?
SQL:
SELECT name ,  max(revenue) ,  Headquarter FROM manufacturers GROUP BY Headquarter