Find the salaries of all distinct instructors that are less than the largest salary.
CREATE TABLE instructor (salary INTEGER)
SELECT DISTINCT salary FROM instructor WHERE salary < (SELECT MAX(salary) FROM instructor)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE instructor (salary INTEGER) Question: Find the salaries of all distinct instructors that are less than the largest salary. [/INST] SELECT DISTINCT salary FROM instructor WHERE salary < (SELECT MAX(salary) FROM instructor) </s>