问题详情

基于教学视频中的数据库案例，下列SQL语句能够正确查询出“课程编号为‘C01’的成绩高于90分的男生的学号”的有（）。

A．SELECT SNO FROM S, SC WHERE S.SNO=SC.SNO AND CNO=’C01’AND GRADE>90 AND SEX=’男’;

B．SELECT SNO FROM S WHERE SEX=’男’AND SNO IN (SELECT SNO FROM SC WHERE CNO=’C01’AND GRADE>90) ;

C．SELECT SNO FROM SC WHERE CNO=’C01’AND GRADE>90 EXCEPT SELECT SNO FROM S WHERE SEX=’女’;

D．SELECT SNO FROM S WHERE SEX=’男’ EXCEPT SELECT SNO FROM SC WHERE CNO=’C01’AND GRADE>90 ;