题解 | #月均完成试卷数不小于3的用户爱作答的类别#

月均完成试卷数不小于3的用户爱作答的类别

https://www.nowcoder.com/practice/b1d13efcfa0c4ecea517afbdb9090845

select tag,count(tag) as tag_cnt from exam_record join examination_info on exam_record.exam_id=examination_info.exam_id where uid in(select uid from exam_record where submit_time is not null group by uid having count(exam_id)/count(distinct date_format(start_time,"%Y%m")) >=3) group by tag order by tag_cnt desc

全部评论

相关推荐

2025-12-04 15:23
三峡大学 FPGA工程师
不知道怎么取名字_:玩游戏都写到简历上了啊
投递BOSS直聘等公司8个岗位
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务