题解 | #统计作答次数#
得分不小于平均分的最低分
http://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
SELECT MIN( er.score ) min_score_over_avg FROM exam_record er JOIN examination_info ei ON er.exam_id = ei.exam_id WHERE ei.tag='SQL' AND er.score>=(SELECT ROUND(AVG(er.score),1) avg_score FROM exam_record er JOIN examination_info ei ON er.exam_id = ei.exam_id WHERE ei.tag='SQL') ;
投递滴滴等公司9个岗位 >
