LeetCode 1350: Students With Invalid Departments [SQL]

Solution and walkthrough of leetcode database problem 1350: Students With Invalid Departments. I'm using MySQL but this solution should work in any SQL dialect such as PostgreSQL, SQL Server, etc.

Playlists:

[shubham]

Since morning I've been watching you videos. Keep up the good work and soon you'll blow up....Thank you for all the efforts. Love from India.

[BluEN]

select id, name from Students where department_id NOT IN (select id from Departments)

[pareshpal]

can we simply use students.department_id != Departments.id

[irislynn]

dumb question : i wanted to use students.department_id <> departments.id, why is it wrong ?