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
SELECT name ,  max(revenue) ,  Headquarter FROM manufacturers GROUP BY Headquarter
[{'Name': 'Creative Labs', 'max(revenue)': 100.0, 'Headquarter': 'Austin'}, {'Name': 'Iomega', 'max(revenue)': 200.0, 'Headquarter': 'Beijing'}, {'Name': 'Hewlett-Packard', 'max(revenue)': 50.0, 'Headquarter': 'Los Angeles'}, {'Name': 'Winchester', 'max(revenue)': 30.0, 'Headquarter': 'Paris'}, {'Name': 'Fujitsu', 'max(revenue)': 130.0, 'Headquarter': 'Taiwan'}, {'Name': 'Sony', 'max(revenue)': 120.0, 'Headquarter': 'Tokyo'}]