web | Java

写出SQL 1)score表结构:uid,subject_id,score 2)找出所有科目成绩都大于某一学科平均成绩的学生

千锋教育

select uid from ( select uid, if(score>avg_score,0,1) flag from 


( --先求出各个学科的平均成绩select uid, score, avg(score) over(partition by subject_id) avg_score from score )t1 )t2 group by uid having sum(flag)=0;