select sid,sum(score)as 总成绩,row_number() over (order by sum(score) desc) as 排名
from SC
group by sid
order by 总成绩 desc ;
Student表:
SC表:
Teacher表:
Course表:
select sid,sum(score)as 总成绩,row_number() over (order by sum(score) desc) as 排名
from SC
group by sid
order by 总成绩 desc ;
Student表:
SC表:
Teacher表:
Course表: