Find the name, headquarter and revenue of all manufacturers sorted by their revenue in the descending order.
CREATE TABLE manufacturers (name VARCHAR, headquarter VARCHAR, revenue VARCHAR)
SELECT name, headquarter, revenue 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 the name, headquarter and revenue of all manufacturers sorted by their revenue in the descending order. [/INST] SELECT name, headquarter, revenue FROM manufacturers ORDER BY revenue DESC </s>