select uid, count(score) as exam_complete_cnt from exam_record er where date_format(start_time, '%Y%m') not in ( select date_format(start_time, '%Y%m') as time1 from exam_record where submit_time is null ) group by uid having count(score) >= 3 order by exam_complete_cnt desc, uid desc 我这样写 哪里有问题 我觉得逻辑也对呀
点赞

相关推荐

肖先生~:先别说工资,现在有个工作就不错了
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务