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

What is the name of the project that has a scientist assigned to it whose name contains 'Smith'?
SELECT T2.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project = T2.code JOIN scientists AS T3 ON T1.scientist = T3.ssn WHERE T3.name LIKE '%Smith%'
SELECT "T2"."name" FROM "assignedto" AS "T1" JOIN "projects" AS "T2" ON "T1"."project" = "T2"."code" JOIN "scientists" AS "T3" ON "T1"."scientist" = "T3"."ssn" AND "T3"."name" LIKE '%Smith%'