SELECT job_id FROM job_history WHERE end_date - start_date  > 300 GROUP BY job_id HAVING COUNT(*) >= 2
display job ID for those jobs that were done by two or more for more than 300 days.
SELECT job_id FROM job_history WHERE end_date - start_date > 300 GROUP BY job_id HAVING COUNT ( * ) > = 2
select job_id from job_history where end_date - start_date > value group by job_id having count ( * ) > = value
display job ID for those jobs that were done by two or more for more than 300 days .