What is the lowest salary for someone with the title MK_MAN?
select min(salary) from employees where job_id = 'MK_MAN'
Which employees make less than that?
select * from employees where salary < ( select min(salary) from employees where job_id = 'MK_MAN' )
What are their employee ids and job ids?
select employee_id, job_id from employees where salary < ( select min(salary) from employees where job_id = 'MK_MAN' )