how many scientists are in the table?
select count(*) from scientists
how many projects are there？
select count(*) from projects
list all of the project names.
select name from projects
Find the number of scientists involved in each of them.
select count(*), t1.name from projects as t1 join assignedto as t2 on t1.code = t2.project group by t1.name