Untitled

 avatar
unknown
plain_text
5 months ago
236 B
2
Indexable
SELECT CONCAT(P.FName, ' ', P.LName) AS ProfessorName, 
       C.CourseName, 
       A.AssignmentType, 
       A.StuAvgTime
FROM professor P
JOIN course C ON P.ProfEmail = C.ProfEmail
JOIN assignments A ON C.CourseID = A.CourseID;
Editor is loading...
Leave a Comment