Database: scientist_1
Question: Select the project names which are not assigned yet.
SQL:
SELECT Name FROM Projects WHERE Code NOT IN (SELECT Project FROM AssignedTo)