select s2.name,s1.cnt from  (select subject_id,count(id) as cnt from submission where create_time = '2023-05-17'
group by subject_id)  s1
left join subject s2
on s1.subject_id=s2.id
order by cnt desc,subject_id