Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.

### Instruction:

Convert text to sql: Select the project names which are not assigned yet. | scientists : ssn , name | projects : code , name , hours | assignedto : scientist , project | assignedto.project = projects.code | assignedto.scientist = scientists.ssn | 

### Response:

select _ from _ where _ not in ( select _ from _ ) | select name from projects where code not in ( select project from assignedto )