select avg(score) `班级为2020的所有学生科目"PE"的平均分` from ( select * from student where class = '2020' )
t1 join ( select student_num,score from course_score where courese = 'PE' )
t2 on t1.num = t2.student_num
select avg(score) `班级为2020的所有学生科目"PE"的平均分` from ( select * from student where class = '2020' )
t1 join ( select student_num,score from course_score where courese = 'PE' )
t2 on t1.num = t2.student_num