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;