单项选择题
在“班级表t_class”中,查询“学生人数”在40~50之间的班级,要求只显示班级 编号、班级名称和学生人数。
A、SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE stu_number BETWEEN 40 AND 50
B、SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number BETWEEN 40 AND 50
C、SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number FROM 40 AND 50
D、SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number BETWEEN 40 TO 50