题解 | #今天的刷题量(一)#
今天的刷题量(一)
https://www.nowcoder.com/practice/e18f56796ae94c3d885e61c8d57a950e
with a as(
select subject_id,count(subject_id) cnt
from submission
where create_time='2024-07-28'
group by subject_id
)
select name,cnt
from a join subject s on a.subject_id=s.id
order by cnt desc,subject_id
