单选题
对于学生信息表STUDENT(SNO,SNAME,SEX,AGE,DEPT) (STUDENT由学号SNO、姓名SNAME、性别SEX、年龄AGE、所在系DEPT5个属性组成,其中SNO为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是( )。 A.SELECT SNAME,AGE FROM STUDENT WHERE AGE>20 AND AGE<23 B.SELECT*FROM STUDENT WHERE AGE BETWEEN 20 AND 23 C.SELECTSNAME,AGE FROM STUDENT WHERE AGE BETWEEN 20 AND 23 D.以上均不正确