CREATE TABLE assignedto (scientist NUMBER, project CLOB)
CREATE TABLE scientists (ssn NUMBER, name CLOB)
CREATE TABLE projects (code CLOB, name CLOB, hours NUMBER)

What is the name of the project that requires the fewest number of hours, and the names of the scientists assigned to it?
SELECT T2.name, T3.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project = T2.code JOIN scientists AS T3 ON T1.scientist = T3.ssn WHERE T2.hours = (SELECT MIN(hours) FROM projects)
SELECT "T2"."name", "T3"."name" FROM "assignedto" "T1" JOIN "projects" "T2" ON "T1"."project" = "T2"."code" AND "T2"."hours" = (SELECT MIN("hours") FROM "projects") JOIN "scientists" "T3" ON "T1"."scientist" = "T3"."ssn"