select t3.score min_score_over_avg from exam_record t3 inner join examination_info t4 on t3.exam_id=t4.exam_id where t3.score>= (select avg(t1.score) from exam_record t1 inner join examination_info t2 on t1.exam_id=t2.exam_id where t2.tag='SQL') and t4.tag='SQL' order by t3.score limit 1 我是这样写的,多执行几次后显示过关~所以这样写没毛病吧,哈哈
点赞

相关推荐

11-06 16:50
门头沟学院 Java
用微笑面对困难:word打字比赛二等奖的我,也要来凑合凑合
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务