SQL数据汇总查询,高分

呵呵，少看了一行。select stu_school as '所在学校',(select count(*) from ask_info where stu_school=a.stu_school and state=0) as '咨询中',(select count(*) from ask_info where stu_school=a.stu_school and state=1) as '已报名',(select count(*) from ask_info where stu_school=a.stu_school and state=10) as '已上课',(select count(*) from ask_info where stu_school=a.stu_school) as '总计' from ask_info a group by stu_schoolunion select '总计',(select count(*) from ask_info where state=0) as '咨询中',(select count(*) from ask_info where state=1) as '已报名',(select count(*) from ask_info where state=10) as '已上课',(select count(*) from ask_info ) as '总计' 收起