السلام عليكم ورحمة الله وبركاته
SELECT e.employee_id, last_name,e.job_id
FROM employees e
WHERE 2 <= (SELECT COUNT(*)
FROM job_history
WHERE employee_id = e.employee_id);
--------------
ما معنى هذا الاستعلام ...
وما معنى الرقم 2 .....

GIVE ME THE INFO (ID,NAME,JOB)
ABOUT ANY EMPLOYEE(FROM EMP TABLE) THAT HAVE 2 RECORDS OR LESS IN (THE HIST TABLE) WHICH THAT MEANS HE CHANGED HIS JOB 2 OR LESS TIMES