34,590
社区成员
发帖
与我相关
我的任务
分享
select top 3 b.课程名,a.学生号,a.成绩
from (select 学生课程号,学生号,sum(成绩) as 成绩 from sorce group by 学生课程号,学生号)a ,
lessoninfo b
where a.学生课程号 = b.课程号
order by 成绩 desc ]
SQL code
select top 3 a.学号,a.姓号 b.课程名, c.学生号,sum(c.成绩) 总成绩 ,
优秀率=max((select count(*) from score where 成绩>85)/count(*)),
合格率=max((select count(*) from score where 成绩>60)/count(*))
from studentinfo a left join c
on a.学号=c.学号
join lessoninfo b on b.课程号=c.课程号
group by a.学号,b.姓名,b.课程名,c.学生号
order by 总成绩 desc
select top 3 b.课程名,a.学生号,a.成绩
from (select 学生课程号,学生号,sum(成绩) as 成绩 from sorce group by 学生课程号,学生号)a ,
lessoninfo b
where a.学生课程号 = b.课程号
order by 成绩 desc