find the name of the project that has taken the most time.
select name from projects order by hours desc limit 1
how may hours have been spent on it?
select hours from projects order by hours desc limit 1
how many scientists are working on the project?
select count(*) 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)
what are their names?
select 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)
how about those who are not involved in it? List their names.
select name from scientists except select 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)