Schema: CREATE TABLE Projects (Name VARCHAR, Code VARCHAR, Project VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, Code VARCHAR, Project VARCHAR)
Question: Select the project names which are not assigned yet.
SQL: SELECT Name FROM Projects WHERE NOT Code IN (SELECT Project FROM AssignedTo)