在SQL Server 2000中，查询表STUDENT1中所有成绩在300～320的学生。在查询分析器中应执行______

A.SELECT * FROM STUDENT1 WHERE CJ＞300 AND CJ＜320
B.SELECT * FROM STUDENT1 WHERE CJ BETWEEN 310 AND 320
C.SELECT * FROM STUDENT1 WHERE CJ BETWEEN 300 AND 320
D.以上都不对