Need to find the employees who have switched jobs atleast twice
Your Query should be like:

SELECT * FROM job_history INNER JOIN employees 
ON job_history.employee_id = employees.employee_id
WHERE job_history.employee_ID IN
    (SELECT employee_id
         FROM job_history
         GROUP BY employee_id
         HAVING COUNT(employee_id) &gt;= 2
    );


so you missed the alias before the id "WHERE job_history.employee_ID IN..", and the where in change it to what above...