#今天的刷题量(一)#

此题目为阅读理解

什么今天昨天都是混淆视听
	 current_date 返回当前的日期,如:2022-03-15 差点就用now了

```select b.name,count(a.subject_id) as cnt 
from submission a 
inner join subject b 
on a.subject_id = b.id 
where a.create_time = current_date
group by b.name,a.subject_id
order by cnt desc,a.subject_id

我发现这样也能过 可能不严谨
select b.name,count(a.subject_id) as cnt 
from submission a 
inner join subject b 
on a.subject_id = b.id 
where a.create_time = current_date
group by b.name
order by cnt desc