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 我这样写 哪里有问题 我觉得逻辑也对呀
点赞

相关推荐

12-15 12:50
河北工程大学
sta666:我也是这个国际商业化的,三天,一天一面,就通过了,不过我是后端实习生,好好面感觉能过。
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务