There are three tables, Student table SC table and course table;

There are three tables, Student table SC table and course table;
Student Table: School number SNO, name sname, sex ssex
Course Table: Course number CNO, course name cname, credits Ccredit
SC table: School Number SNO, course number CNO, results grade
Please use SQL statement to query student name and total course credits

(Note: If the course fails, then this course is divided into 0)

Answer:

Select St.sname,sum (cou.ccredit) from SC t
Left join COURSE cou on cou.cno = T.cno
Left JOIN student St. St.sno = T.sno
where T.grade >= 60
GROUP BY St.sname

Take the credits and get the credits, then sum up.