Make view named SCSP_VIEW using joins. Reuse what you did in the FROM clause from your saved
Question:
Make view named SCSP_VIEW using joins.
Reuse what you did in the FROM clause from your saved Expanded Rollup script
Update your view to return the following columns
StudentID, CourseID, SectionID, ProfessorID, StudentFirstName, StudentLastName, CourseName, SectionName, ProfessorFirstName, ProfessorLastName
EXPANDED ROLLUP
FROM DEPARTMENT_CC
INNER JOIN PROGRAM_CC ON DEPARTMENT_CC.DepartmentID = PROGRAM_CC.DepartmentID
LEFT JOIN PROGRAM_COURSE_INT_CC ON PROGRAM_CC.ProgramID = PROGRAM_COURSE_INT_CC.ProgramID
LEFT JOIN COURSE_CC ON COURSE_CC.CourseID = COURSE_CC.CourseID
LEFT JOIN SECTION_CC ON COURSE_CC.CourseID = SECTION_CC.SectionID
LEFT JOIN STUDENT_CC ON SECTION_CC.SectionID = STUDENT_CC.StudentID
LEFT JOIN SECTION_CC ON Student_cc.StudentID = Section_CC.SectionID
GROUP BY(DEPARTMENT_CC.DepartmentName, PROGRAM_CC.ProgramName, COURSE_CC.CourseID, COURSE_CC.CourseName, SECTION_CC.SectionName);
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill