web | Java

写出SQL 1)student表,student(id,num,name,class),字段说明:num(学号)、name(学生姓名)、class(班级) 2)course_score表,course_score(student_num,course,score),字段说明:student_num(学号)、courese(科目)、score(分数) 3)查询班级为"2020"的所有学生科目"PE"的平均分

千锋教育

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