USE FUH_UNIVERSITY

SELECT tblStudent.stuName, SUM(tblReport.repPracticle)AS Grade
INTO #tblStudentReport
FROM tblStudent, tblReport
GROUP BY tblStudent.stuName

SELECT tblStudent.stuName, tblStudent.stuBirthdate, tblStudent.claCode
FROM tblStudent, tblClass, tblInstructor, tblReport, #tblStudentReport
WHERE tblClass.insSSN = tblInstructor.insSSN
    AND tblInstructor.insName = N'Nguyễn Khánh Nhân'

DROP TABLE #tblStudentReport