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