What is the name of the project with the highest hours?
select name from projects order by hours desc limit 1
What is the code of the project A Magnetic Primer Designer?
select code from projects where name = 'A magnetic primer Designer'
Who are the scientists who are not assigned to the project Bte2?
select scientist from assignedto where project ! = 'Bte2'