select job, 
ceiling(max(r)/2),
case when max(r)%2=0 then ceiling(max(r)/2)+1 else ceiling(max(r)/2) end
from(
select job, row_number()over(partition by job order by score) as r
from grade) as tb1
group by job