select f.id,f.job,f.score,f.t_rank from ( select distinct n1.id,n1.job,n1.score,n1.t_rank from( select id,job,score,row_number() over(partition by job order by score desc) as t_rank from grade) as n1 join (select n.job,case when mod(n.num,2) =0 then round(n.num/2,0) else round((n.num+1)/2,0) e...