需要mysql查询，以获得学生的总分或总和的4列(特雷古语，数学，社会，英语)在单一查询

SELECT 
    student_id, 
    SUM(teregu_language + math + social + english) AS total_score
FROM 
    student_scores
GROUP BY 
    student_id;

ALTER TABLE student_scores MODIFY teregu_language INT;
ALTER TABLE student_scores MODIFY math INT;
ALTER TABLE student_scores MODIFY social INT;
ALTER TABLE student_scores MODIFY english INT;

SELECT 
    student_id, 
    SUM(IFNULL(teregu_language, 0) + IFNULL(math, 0) + IFNULL(social, 0) + IFNULL(english, 0)) AS total_score
FROM 
    student_scores
GROUP BY 
    student_id;

CREATE TABLE student_scores (
    student_id INT PRIMARY KEY,
    teregu_language INT,
    math INT,
    social INT,
    english INT
);

INSERT INTO student_scores (student_id, teregu_language, math, social, english)
VALUES (1, 85, 90, 78, 88),
       (2, 75, 80, 85, 90);

SELECT 
    student_id, 
    SUM(teregu_language + math + social + english) AS total_score
FROM 
    student_scores
GROUP BY 
    student_id;

student_id | total_score
-----------|-------------
1          | 341
2          | 330