SELECT job_id FROM job_history WHERE end_date - start_date  > 300 GROUP BY job_id HAVING COUNT(*) >= 2
What are the job ids for jobs done more than once for a period of 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
What are the job ids for jobs done more than once for a period of more than 300 days ?