EXCEPT
Returns rows in first query but not in second.
sql
1SELECT course FROM all_courses
2EXCEPT
3SELECT course FROM active_courses;Courses not currently active.

Returns rows in first query but not in second.
1SELECT course FROM all_courses
2EXCEPT
3SELECT course FROM active_courses;Courses not currently active.