display all the information of those employees who did not have any job in the past.
CREATE TABLE job_history (employee_id VARCHAR); CREATE TABLE employees (employee_id VARCHAR)
SELECT * FROM employees WHERE NOT employee_id IN (SELECT employee_id FROM job_history)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE job_history (employee_id VARCHAR); CREATE TABLE employees (employee_id VARCHAR) Question: display all the information of those employees who did not have any job in the past. [/INST] SELECT * FROM employees WHERE NOT employee_id IN (SELECT employee_id FROM job_history) </s>