sql面试练习题

sql语句：

SELECT * into #t from ( select  B.sid,A.name,b.score from student  A,Score B
WHERE A.id=b.sid  group by b.sid,a.name,b.score)k
select * from (
select DISTINCT M.name,SUM(score)  over(order by sid) as  TotalScore  from #T as M
) A order  by a.TotalScore  desc

 DROP TABLE #T