group之前可加where

select sum(Score) as sum_Score, name from StuScore 
where name <> '张三'
group by name
order by sum_Score desc