select 
  name,
  count(*) as cnt 
from
  submission as s1
join 
  subject as s2
on 
  s1.subject_id=s2.id
where
  create_time=CURDATE()
group by 
  name,
  subject_id
order by 
  cnt desc,
  subject_id;