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

Transcribed Image Text:

FP_Course Typ Course TypeID(FK) AUTOINT(11) Course TypeName varchar(50) FP_Course CourseID(PK CourseName Course TypeID(FK) ProgramID(FK) AUTOINT(11) + varchar(50) INT(11) INT(11) ProgramID(PK) ProgramName DepartmentID(FK) INT(11) FP_Program InstructorID(PK) FirstName LastName DepartmentID(FK) Term FP_Instructor CatalogID(PK) RoomID CourseID(FK) InstructorID(FK) Grades AUTOINT(11) varchar(50) FP_Catalog EnrollmentID AUTOINT(11) varchar(50) CourselD(FK StudentID(FK) varchar (50) INT(11) AUTOINT(11) varchar(50) FP_Enrollment INT(11) INT(11) INT(11) AUTOINT(11) INT(!1 INT(11) INT(11) FP_Department DepartmentID(PK) AUTOINT(11) DepartmentName varchar(50) LocationID(PK) AUTOINT(11) LocationName varchar(50 FP_Location +RoomID(PK) FP_Room RoomNumber int(11) LocationID(FK int(11 FirstName LastName Address City State Zip UnitCost AUTOINT(11) FP_StudentRegistration StudentID(PK) AUTOINT(11 varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) int(11) int(11) FP_Course Typ Course TypeID(FK) AUTOINT(11) Course TypeName varchar(50) FP_Course CourseID(PK CourseName Course TypeID(FK) ProgramID(FK) AUTOINT(11) + varchar(50) INT(11) INT(11) ProgramID(PK) ProgramName DepartmentID(FK) INT(11) FP_Program InstructorID(PK) FirstName LastName DepartmentID(FK) Term FP_Instructor CatalogID(PK) RoomID CourseID(FK) InstructorID(FK) Grades AUTOINT(11) varchar(50) FP_Catalog EnrollmentID AUTOINT(11) varchar(50) CourselD(FK StudentID(FK) varchar (50) INT(11) AUTOINT(11) varchar(50) FP_Enrollment INT(11) INT(11) INT(11) AUTOINT(11) INT(!1 INT(11) INT(11) FP_Department DepartmentID(PK) AUTOINT(11) DepartmentName varchar(50) LocationID(PK) AUTOINT(11) LocationName varchar(50 FP_Location +RoomID(PK) FP_Room RoomNumber int(11) LocationID(FK int(11 FirstName LastName Address City State Zip UnitCost AUTOINT(11) FP_StudentRegistration StudentID(PK) AUTOINT(11 varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) int(11) int(11)