select t2.name,count(t1.subject_id) as cnt
from submission t1
     left join subject t2 on t1.subject_id=t2.id
where create_time=current_date
group by subject_id,t2.name
order by cnt desc,subject_id asc