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

i.e. would produce unit cost of courses grouped by student

CoursHeroTranscribedText

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