题解 | 今天的刷题量(一)
今天的刷题量(一)
https://www.nowcoder.com/practice/e18f56796ae94c3d885e61c8d57a950e
select name,count(
(case when create_time=curdate() then 1
end)
) as cnt from submission sub left join subject s on sub.subject_id =s.id
group by subject_id,name
order by cnt desc,subject_id asc
#注意count对所有非null值都计数 包括else 0，curdate（）返回今天的日期
投递影石Insta360等公司10个岗位 >