https://www.nowcoder.com/feed/main/detail/297b1a65c5e143f892ba8b4437e61d89

SELECT id, name, SUM(score) AS total_score FROM students GROUP BY id, name ORDER BY name;