CREATE TABLE assignedto (scientist DECIMAL, project TEXT)
CREATE TABLE projects (code TEXT, name TEXT, hours DECIMAL)
CREATE TABLE scientists (ssn DECIMAL, name TEXT)

What are the names of projects that have not been assigned?
SELECT name FROM projects WHERE NOT code IN (SELECT project FROM assignedto)
SELECT "name" FROM "projects" WHERE NOT "code" IN (SELECT "project" FROM "assignedto")