web | Java

写出SQL查询所有科目大于80分的学生的姓名

千锋教育

select num,name from student s join ( select student_num from course_score group by student_num having score > 80 ) 


t1 on s.num = t1.student_num; select s.num,s.name from student s left join ( select student_num from course_score where score <= 80 group by student_num ) 


t1 on s.num = t1.student_num where t1.student_num is null;