instruction: For those employees who do not work in departments with managers that have ids between 100 and 200, a line chart shows the trend of salary over hire_date , I want to order by the X in ascending.
response: SELECT HIRE_DATE, SALARY FROM employees WHERE NOT DEPARTMENT_ID IN (SELECT DEPARTMENT_ID FROM departments WHERE MANAGER_ID BETWEEN 100 AND 200) ORDER BY HIRE_DATE