SELECT employee_id FROM job_history GROUP BY employee_id HAVING COUNT(*)  >= 2
display the ID for those employees who did two or more jobs in the past.
SELECT employee_id FROM job_history GROUP BY employee_id HAVING COUNT ( * ) > = 2
select employee_id from job_history group by employee_id having count ( * ) > = value
display the ID for those employees who did two or more jobs in the past .