Tough one to title. But, I'm looking to query for 'outliers'.
Basically, I'm looking for all courses that have not been taken by a student. A table full of students are required to take 'x' amount of specified courses in a given curriculum. I can query which courses have been taken by whom, but I don't know how to query the students who have not taken any required course.
Three tables.
- All Courses - a list of all required courses that a student must take.
- Roster - basically a list of students, IDs, etc.
- Course completions - All course activity is recorded here. If and when a course was taken.
In this example you can clearly see that none of the students (Course Completions) have taken the "Onboarding" or "New Hire" courses (All Courses). Joe has only taken "Leadership I", and there's a mix of others. I want to be able to identify each of the students and pull the courses which they haven't taken. This would effectively produce an "outlier" query. I'm stumped.
Any suggestions? Thanks.