Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Employees Without Projects

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.