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

Find the SSN and name of scientists who are assigned to the project with the longest hours.
SELECT T3.SSN, 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 MAX(hours) FROM projects)
SELECT "T3"."SSN", "T3"."name" FROM "assignedto" "T1" JOIN "projects" "T2" ON "T1"."project" = "T2"."code" AND "T2"."hours" = (SELECT MAX("hours") FROM "projects") JOIN "scientists" "T3" ON "T1"."scientist" = "T3"."SSN"