Generate a single SQL query that uses SUM, JOIN, and GROUP BY functions based on the ERD

 

 

 

Transcribed Image Text:

FP_Program ProgramID (PK) ProgramName DepartmentID FP_Department DepartmentID (PK) DepartmentName FP_Course Type PK Course TypeID Course TypeName FP_Instructor InstructorID (PK) FirstName LastName FP_Location LocationID (PK) Location Name FP_Course PK CourseID CourseName Course TypeID ProgramID DepartmentID FP_Catalog CatalogID (PK) Term InstructorID RoomID FP_Room RoomID (PK) RoomNumber LocationID FP_StudentRegistration StudentID (PK) FirstName CourseID LastName Address FP Enrollment EnrollmentID (PK) Grades CatalogID City State Zip UnitCost StudentID FP_Program ProgramID (PK) ProgramName DepartmentID FP_Department DepartmentID (PK) DepartmentName FP_Course Type PK Course TypeID Course TypeName FP_Instructor InstructorID (PK) FirstName LastName FP_Location LocationID (PK) Location Name FP_Course PK CourseID CourseName Course TypeID ProgramID DepartmentID FP_Catalog CatalogID (PK) Term InstructorID RoomID FP_Room RoomID (PK) RoomNumber LocationID FP_StudentRegistration StudentID (PK) FirstName CourseID LastName Address FP Enrollment EnrollmentID (PK) Grades CatalogID City State Zip UnitCost StudentID