SELECT e.first_name, e.last name, j.job title, d.department_name FROM employees e JOIN departments d ON e.department id = d.department_id JOIN jobs1 ON e.job_id=j.job_id WHERE e.department_id IN (1, 2, 3) AND e.salary > 10000;
