SELECT s.name, COUNT(*) AS cnt
FROM submission AS sub
JOIN subject AS s ON sub.subject_id = s.id
WHERE DATE(sub.create_time) = CURDATE()
GROUP BY s.name, s.id
ORDER BY cnt DESC, s.id ASC;