在mysql 中 可用 current_date表示当日的日期

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