with a as(
    select subject_id,count(subject_id) cnt
    from submission
    where create_time='2024-07-28'
    group by subject_id
)
    select name,cnt
    from a join subject s on a.subject_id=s.id
    order by cnt desc,subject_id