有一个course(课程)表,包含字段:cName(课程名称),grade(学分)。要从此表中查询所有学分不在1~4之间的课程名称,以下语句正确的是()。 (选择两项)
A.
SELECT cName FROM course WHERE grade IN(1,4)
B.
SELECT cName FROM course WHERE grade NOT BETWEEN 1 AND 4
C.
SELECT cName FROM course WHERE grade NOT BETWEEN 4 AND 1
D.
SELECT cName FROM course WHERE grade NOT (grade>=1 AND grade<=4)