Find the name and revenue of the company that earns the highest revenue in each city.
CREATE TABLE manufacturers (name VARCHAR, Headquarter VARCHAR, revenue INTEGER)
SELECT name, MAX(revenue), Headquarter FROM manufacturers GROUP BY Headquarter
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE manufacturers (name VARCHAR, Headquarter VARCHAR, revenue INTEGER) Question: Find the name and revenue of the company that earns the highest revenue in each city. [/INST] SELECT name, MAX(revenue), Headquarter FROM manufacturers GROUP BY Headquarter </s>