SQL Query: Find the id and name of each student who has not taken any course offered before 2017.

a) SELECT id, name FROM Students WHERE id NOT IN (SELECT student_id FROM Enrollments WHERE course_id IN (SELECT id FROM Courses WHERE year < 2017) ) ;
b) SELECT id, name FROM Students WHERE id NOT IN (SELECT student_id FROM Enrollments WHERE course_id IN (SELECT id FROM Courses WHERE year <= 2017) ) ;
c) SELECT id, name FROM Students WHERE id NOT IN (SELECT student_id FROM Enrollments WHERE course_id IN (SELECT id FROM Courses WHERE year > 2017) ) ;
d) SELECT id, name FROM Students WHERE id NOT IN (SELECT student_id FROM Enrollments WHERE course_id IN (SELECT id FROM Courses WHERE year >= 2017) ) ;

Q&A Education