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

#题单名称+提交量 按提交量降序提单号升序
#当日

select
    name
    ,cnt
from (
        select
            distinct
            name
            ,subject_id
            ,count(m.id)over(partition by subject_id) cnt #提交量
        from submission m
            left join subject s
                on s.id=m.subject_id
        where create_time=curdate()#当日题单名称
        order by 3 desc,2#提交量降序提单号升序
        ) a