多选题

用下面哪些SQL语句可以从table中得到每门课都大于80分的学生姓名，下...

Question

用下面哪些SQL语句可以从table中得到每门课都大于80分的学生姓名，下面说法正确的的？

name   course   fenshu

小张     语文       81

小张     数学       75

小李     语文       76

小李     数学       90

小王     语文       81

小王     数学       100

小王     英语       90

A. select distinct a.name from table a left join (select distinct name from table where fenshu <= 80) b on a.name=b.name where b.name is null

B. select name from table where fenshu > 80 group by name having cnt > 0

C. select distinct name from table where name in (select distinct name from table where fenshu > 80)

D. select name,sum(case when fenshu<=80 then 1 else 0 end) scr from table group by name having scr=0