Lecture 3: CCIS2701 DB Design: Not-so-simple joins

SELECT firstname, surname, class.name FROM student LEFT JOIN assignment_score ON student.id = assignment_score.studentid JOIN class_student ON class_student.studentid = student.id JOIN class ON class_student.classid = class.id WHERE assignment_score.studentid IS NULL
lets go through the above...
finds everyone who doesn't have ANY score listed...