在“班级表t_class”中，查询“学生人数”在4...

A. A.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE stu_number BETWEEN 40 AND 50

B. B.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number BETWEEN 40 AND 50

C. C.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number FROM 40 AND 50

D. D.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number BETWEEN 40 TO 50

在“班级表t_class”中，查询“学生人数”在40～50之间的班级，要求只显示班级编号、班级名称和学生人数。