将student表按照gender字段值进行分组查询，并计算出每个分组中各有多少名学生的正确SQL语句是() A、SELECT TOTAL(*),gender FROM student GROUP BY gender; B、SELECT COUNT(*),gender FROM student GROUP BY gender; C、SELECT TOTAL(*),gender FROM student ORDER BY gender; D、SELECT COUNT(*),gender FROM student ORDER BY gender;