一张学生成绩表内SQL查询每个班级每门课程的平均分
答案:3 悬赏:50
解决时间 2021-01-15 00:15
- 提问者网友：难遇难求
- 2021-01-14 00:34
一张学生成绩表内SQL查询每个班级每门课程的平均分
最佳答案
- 二级知识专家网友：神鬼未生
- 2021-01-14 01:49
select avg(分数) as 平均分, rtrim(cast(sum(case when 分数>=60 then 1 end)/count(*)*100 as char(10)))+'%' as 及格率 from A group by 班级,课程
全部回答
- 1楼网友：纵马山川剑自提
- 2021-01-14 04:58
平均分：
select avg(分数) from a group by 班级,课程
及格率：
select (select count(*) from a where 分数>60 group by 班级,课程)
/(select count(*) from a group by 班级,课程)
select avg(分数) from a group by 班级,课程
及格率：
select (select count(*) from a where 分数>60 group by 班级,课程)
/(select count(*) from a group by 班级,课程)
- 2楼网友：独钓一江月
- 2021-01-14 03:28
---------------------------------------------------
-- sql script for SQL Server
--
---------------------------------------------------
SELECt
[班级],
[课程],
avg([分数]) as [平均分],
SUM(CASE WHEN [分数]>=60 THEN 1 ELSE 0 END)/COUNT(*) AS [及格率]
FROM [成绩]
GROUP BY [班级],[课程]
-- sql script for SQL Server
--
---------------------------------------------------
SELECt
[班级],
[课程],
avg([分数]) as [平均分],
SUM(CASE WHEN [分数]>=60 THEN 1 ELSE 0 END)/COUNT(*) AS [及格率]
FROM [成绩]
GROUP BY [班级],[课程]
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息！
大家都在看
推荐信息