题解 | 今天的刷题量(一)
今天的刷题量(一)
https://www.nowcoder.com/practice/e18f56796ae94c3d885e61c8d57a950e
select
p2.name,
cnt
from
(
select
subject_id,
count(*) as cnt
from
submission
where
create_time = current_date
group by
subject_id
) as p1
inner join subject as p2 on p1.subject_id = p2.id
order by
cnt desc,
p1.subject_id asc;
腾讯一面2288人在聊