SELECT t2.fName, t2.lName, t1.mid, t2. final, (t1.g1+t1.g2+t1.g3+t1.g4+t1.mid+t1.g6+t1.g7+t1.g8+t1.g9+t1.final) AS TOTAL FROM all_grades AS t1,students AS t2 WHERE t1.stuID = t2.StuID
StudentMid-termFinal ExamTotal