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

select b.name,count(a.subject_id) as cnt
from submission as a
inner join subject as b
on a.subject_id=b.id 
where create_time = '2023-02-27'
group by name
order by cnt DESC