查询学号为 “ 201215121 ”和学号为“ 201215122 ”的两个学生中学生选修过的课程的课程号,可以使用的 SQL 语句是:( )
A.
SELECT Cno FROM SC WHERE Sno NOT IN ('201215121', '201215122');
B.
SELECT Cno FROM SC WHERE Sno = '201215121' OR Sno = '201215122';
C.
SELECT Cno FROM SC WHERE Sno = '201215121' AND Sno = '201215122';
D.
SELECT Cno FROM SC WHERE Sno != '201215121' OR Sno != '201215122';