单项选择题

对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20~22岁之间的学生的姓名和学号的语句是( )。

A.SELECF FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname, sno FROM student WHERE age>=20
D.SELECT sname, sno FROM student WHERE age<=22