how many projects are there?
select count(*) from projects
among them, how many are not assigned yet?
select count(*) from projects where code not in (select project from assignedto)
what are the names of these projects?
select name from projects where code not in (select project from assignedto)