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

Find the name and hours of project that has the most number of scientists.
SELECT T1.name, T1.hours FROM projects AS T1 JOIN assignedto AS T2 ON T1.code = T2.project GROUP BY T2.project ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."name", "T1"."hours" FROM "projects" "T1" JOIN "assignedto" "T2" ON "T1"."code" = "T2"."project" GROUP BY "T2"."project" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY