|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
我算的和上面的几个答案结果有几个数据不一样。
select 班级,"语文" as 科目,sum(iif(语文>72,1,0))/sum(1) as 比例 from [五原文化课总成绩$]group by 班级 union all select 班级,"数学",sum(iif(数学>72,1,0))/sum(1) from [五原文化课总成绩$]group by 班级 union all select 班级,"英语",sum(iif(英语>72,1,0))/sum(1) from [五原文化课总成绩$]group by 班级 union all select 班级,"物理",sum(iif(物理>60,1,0))/sum(1) from [五原文化课总成绩$]group by 班级 union all select 班级,"化学",sum(iif(化学>60,1,0))/sum(1) from [五原文化课总成绩$]group by 班级 union all select 班级,"政治",sum(iif(政治>60,1,0))/sum(1) from [五原文化课总成绩$]group by 班级 union all select "合计","语文",sum(iif(语文>72,1,0))/sum(1) from [五原文化课总成绩$] union all select "合计","数学",sum(iif(数学>72,1,0))/sum(1) from [五原文化课总成绩$] union all select "合计","英语",sum(iif(英语>72,1,0))/sum(1) from [五原文化课总成绩$] union all select "合计","物理",sum(iif(物理>60,1,0))/sum(1) from [五原文化课总成绩$] union all select "合计","化学",sum(iif(化学>60,1,0))/sum(1) from [五原文化课总成绩$] union all select "合计","政治",sum(iif(政治>60,1,0))/sum(1) from [五原文化课总成绩$] |
|