find the hours spent on the project that has continued for the longest time.
select max(hours) from projects
what is the name of this project?
select name from projects order by hours desc limit 1
Find the SSN and name of scientists who are assigned to it.
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)