select s.LastSurname,s.FirstName,sar.SchoolYear,dt.CodeValue as TermCode,dt.Description as Term, sar.CumulativeAttemptedCredits,sar.CumulativeEarnedCredits
,sar.CumulativeGradePointsEarned,sar.CumulativeGradePointAverage,sar.SessionAttemptedCredits,sar.SessionEarnedCredits,sar.SessionGradePointsEarned,sar.SessionGradePointAverage,sar.ProjectedGraduationDate
from edfi.StudentAcademicRecord sar
left join edfi.Student s on s.StudentUSI=sar.StudentUSI
left join edfi.Descriptor dt on dt.DescriptorId=sar.TermDescriptorId
order by s.LastSurname,s.FirstName,sar.SchoolYear,dt.CodeValue