use FUH_UNIVERSITY

with tblStudentReport as
(
select tblStudent.stuSSN, AVG(tblReport.repPracticle + tblReport.repPracticle)/2 AS Grade
from tblStudent, tblReport
group by tblStudent.stuSSN
)
select tblStudent.stuName, tblStudent.stuBirthdate, tblStudent.claCode, tblStudentReport.Grade
from tblStudent, tblClass, tblInstructor, tblReport, tblStudentReport

where tblClass.insSSN = tblInstructor.insSSN
    and tblInstructor.insName = N'Nguyễn Khánh Nhân'
    and tblStudentReport.stuSSN = tblStudent.stuSSN