with base as ( select id, job, score, row_number() over(partition by job order by score desc) t_rank, count(*) over(partition by job) job_cnt, case when (count(*) over(partition by job))%2 in (0) then 0 else 1 end as mod_label from grade ) select id,job,sc...