display job Title, the difference between minimum and maximum salaries for those jobs which max salary within the range 12000 to 18000.
CREATE TABLE jobs (job_title VARCHAR, max_salary INTEGER, min_salary VARCHAR)
SELECT job_title, max_salary - min_salary FROM jobs WHERE max_salary BETWEEN 12000 AND 18000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE jobs (job_title VARCHAR, max_salary INTEGER, min_salary VARCHAR) Question: display job Title, the difference between minimum and maximum salaries for those jobs which max salary within the range 12000 to 18000. [/INST] SELECT job_title, max_salary - min_salary FROM jobs WHERE max_salary BETWEEN 12000 AND 18000 </s>