查询学号为“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';
查看答案
查询刘晨同学的学号，可以使用的SQL语句是：
A. SELECT Sno FROM Student WHERE Sname = '刘晨';
B. SELECT Sno FROM Student WHERE Sname == '刘晨';
C. SELECT Sno FROM Student WHERE Sname = "刘晨";
D. SELECT Sno FROM Student WHERE Sname == "刘晨";
假设学号是9位数，前7位表示班级号，后两位表示学生在班级内的序号，如学号201215122表示2012151班的第22位学生。若要查询2012151班所有学生的学号和姓名，（ ）
A. SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151_';
B. SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151__';
C. SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151**';
D. SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151==';
查询曾经考过100分的学生的学号，可以使用的SQL语句是：（ ）
A. SELECT ALL Sno FROM SC WHERE Grade = 100;
B. SELECT DISTINCT Sno FROM SC WHERE Grade = 100;
C. SELECT ALL Sno FROM Student WHERE SC.Grade = 100;
D. SELECT DISTINCT Sno FROM Student WHERE SC.Grade = 100;
查询所有非计算机系学生的信息，不正确的SQL语句是：（ ）
A. SELECT * FROM Student WHERE Sdept != 'CS';
B. SELECT * FROM Student WHERE NOT Sdept = 'CS';
C. SELECT * FROM Student WHERE NOT Sdept IN ('CS');
D. SELECT * FROM Student WHERE Sdept IN ('MA', 'IS');
微信支付 
支付宝支付