SELECT J.employee_id, J.job_id, E.last_name, E.salary
FROM Job_history J join Employees E
ON J.employee_id = E.employee_id
WHERE E.salary BETWEEN 5000 AND 8000;