find the names of all projects.
select name from projects
how many scientists were assigned to each of them?
select t1.name, count(*) from projects as t1 join assignedto as t2 on t1.code = t2.project group by t2.project
which one has the most scientists?
select t1.name from projects as t1 join assignedto as t2 on t1.code = t2.project group by t2.project order by count(*) desc limit 1
show how much time has already been spent on it as well.
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