多选题

如下哪些sql语句能查询出每门课都都大于80分的学生姓名,部分数据如下表(...

Question

如下哪些sql语句能查询出每门课都都大于80分的学生姓名,部分数据如下表(student_score)所示,

stu_no	stu_name	sub_no	sub_name	score
1	张三	001	语文	90
1	张三	002	数学	60
2	李四	001	语文	89
2	李四	002	数学	86

A. select distinct stu_name from student_score where stu_name not in (select distinct stu_name from student_score where score &lt= 80)

B. select stu_name from student_score group by stu_name having min(score) &gt 80

C. select distinct stu_name from student_score where score &gt 80

D. select stu_name from student_score group by sub_name having min(score) &gt 80