What would be an SQL query that uses Sum, join, and group by?

 

 

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