What are all the employee ids for employees who have had a job in the past?
select employee_id from job_history group by employee_id
What is all the information for employees who are not a part of those?
select * from employees where employee_id not in (select employee_id from job_history)