求助？？为什么错误？？

[hooligan31000]

我有一个“学生信息表”，有“班级编号”、“学号”、“年级“、”姓名“、”性别“等字段，做一个查询，查询结果为“班级编号”，“女生人数”，“男生人数”，“总人数”
我是这样写的：但是错误（'性别' 附近有语法错误。）

SELECT 班级, SUM(女生总人数),SUM(男生总人数),SUM(女生总人数)+SUM(男生总人数) AS [总分数] FROM ( SELECT 班级 sum(性别) AS [女生总人数] FROM [info] where 性别='女' GROUP BY [班级] Union SELECT 班级 SUM(性别) AS [男生总人数] FROM [info] where 性别='男' GROUP BY [班级] ) AS T GROUP BY [班级]

请高手指点

[solidpanther]

SELECT 班级编号,年级,SUM(女生总人数),SUM(男生总人数),SUM(女生总人数)+SUM(男生总人数) AS [总分数] FROM 学生信息表 group by 班级编号,年级

[solidpanther]

sorry，更正
SELECT t1.班级编号,t1.年级,
女生总人数=(select count(*) from 学生信息表 where 性别='女' and 班级编号=t1.班级编号,年级=t1.年级)
男生总人数=(select count(*) from 学生信息表 where 性别='男' and 班级编号=t1.班级编号,年级=t1.年级)
总人数 = (select count(*) from 学生信息表 where 性别='女' and 班级编号=t1.班级编号,年级=t1.年级)+
(select count(*) from 学生信息表 where 性别='男' and 班级编号=t1.班级编号,年级=t1.年级)
FROM 学生信息表 t1 group by t1.班级编号,t1.年级

[hooligan31000]

solidpanther(╃╄╃我爱机器猫╄╃╄) :
不对啊，（女生总人数、男生总人数）字段没有。

[hooligan31000]

up