# 创建两张临时表，表1和表2直接对比number，然后将表1满足的条件个数先去重后求和，得出排名；
select pn1.id, pn1.number,
(select count(distinct pn.number) from passing_number as pn where pn.number >= pn1.number) as t_rank
from passing_number as pn1
order by pn1.number desc, pn1.id asc