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;