select distinct job,start,end from ( select job,case when count(row_num) over(partition by job) % 2 = 1 then round(CEILING(count(row_num) over(partition by job) / 2),0) when count(row_num)&n...