select xuehao as 学号,score as 总成绩 from CJB
where xuehao in(select xuehao from XSB)
group by xuehao,score
order by score desc,xuehao
select id as 学号, sum(score) as 总成绩
from 成绩表
group by id
order by sum(score) desc, id asc
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024