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

select
    p2.name,
    cnt
from
    (
        select
            subject_id,
            count(*) as cnt
        from
            submission
        where
            create_time = current_date
        group by
            subject_id
    ) as p1
    inner join subject as p2 on p1.subject_id = p2.id
order by
    cnt desc,
    p1.subject_id asc;