List all employees?
select first_name, last_name from employees
Of these employees, how many did not have a job in the past?
select count ( * ) from employees where employee_id not in ( select employee_id from job_history )
Okay. How many had jobs in the past?
select count ( * ) from employees where employee_id in ( select employee_id from job_history )