List the information of all instructors ordered by their salary in ascending order.
CREATE TABLE instructor (salary VARCHAR)
SELECT * FROM instructor ORDER BY salary
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE instructor (salary VARCHAR) Question: List the information of all instructors ordered by their salary in ascending order. [/INST] SELECT * FROM instructor ORDER BY salary </s>