题解 | #今天的刷题量(一)#

select  distinct t.name name,t.cnt cnt from (select
    s2.name name,s1.subject_id sid,
    count(s1.id) over(partition by s2.id ) cnt
from
    submission s1
    left join subject s2 on s1.subject_id = s2.id
where
    s1.create_time = curdate()
    order by cnt desc,sid asc)t