Employees Without Projects
Easy
Anti & Semi Joins
Return the names of employees who are not assigned to any project. Order by name.
Table schema
Employees(id INT PRIMARY KEY, name VARCHAR(50))
Assignments(emp_id INT, project VARCHAR(20))Sample data
Employees: (1, A), (2, B), (3, C)
Assignments: (1, X), (3, Y)
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.