题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
with sql_avg as ( select avg(score) sql_average from exam_record left join examination_info using (exam_id) where tag = 'SQL' and submit_time is not null ) select min(score) min_score_over_avg from exam_record left join examination_info using (exam_id) where tag = 'SQL' and score >= (select sql_average from sql_avg)
。管你学多少，电子科大的bg就注定了你我的命运不同