select
t1.emp_no,t1.salary,t.t_rank
from(
        select 
            b.salary,
            count(distinct a.salary) t_rank
        from salaries a
        join salaries b
        on a.salary >=b.salary
        group by 1
        order by b.salary desc
    ) t
right join salaries t1
on t.salary=t1.salary
order by t_rank,t1.emp_no