题解 | SQL293 今天的刷题量(一)

select 
	st.name,
	count(sn.create_time) cnt 
from submission sn join subject st 
on sn.subject_id = st.id
where create_time = curdate()
group by sn.subject_id,st.name
order by cnt desc,sn.subject_id ASC;