Find all manufacturers' names and their headquarters, sorted by the ones with highest revenue first.
CREATE TABLE manufacturers (name VARCHAR, headquarter VARCHAR, revenue VARCHAR)
SELECT name, headquarter FROM manufacturers ORDER BY revenue DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE manufacturers (name VARCHAR, headquarter VARCHAR, revenue VARCHAR) Question: Find all manufacturers' names and their headquarters, sorted by the ones with highest revenue first. [/INST] SELECT name, headquarter FROM manufacturers ORDER BY revenue DESC </s>