Leetcode 1350. Students With Invalid Departments

Given Students and Departments tables, return the names of students whose department ID does not match any entry in Departments (i.e., students assigned to an invalid/nonexistent department). This is an anti-join/NOT EXISTS style SQL problem to filter rows with no corresponding foreign key.

Question Timeline

See when this question was last asked and where, including any notes left by other candidates.

Company

Level

Region

Comments

Your account is free and you can post anonymously if you choose.

Hello Interview Premium

Recent interview questions

System Design Guided Practice

Exclusive content

Learn More

Leetcode 1350. Students With Invalid Departments

Question Timeline

Comments

Questions

Learn

Links

Legal

Contact