Select the project names which are not assigned yet.
select name from projects where code not in (select project from assignedto)