题解 | #今天的刷题量(一)#
今天的刷题量(一)
https://www.nowcoder.com/practice/e18f56796ae94c3d885e61c8d57a950e
with t1 as (
select b.name, a.subject_id, create_time
from submission as a
left join subject as b
on a.subject_id = b.id
)
select name, cnt
from (
select name, subject_id, count(create_time) as cnt
from t1
where create_time = CURDATE()
group by name, subject_id
order by cnt desc, subject_id
) as e;
投递快手等公司10个岗位
虾皮信息公司氛围 267人发布