find the names of scientists who are assigned to any projects.
select t1.name from scientists as t1 join assignedto as t2 on t1.ssn = t2.scientist
Find the number of projects each of those scientists is working on.
select count(*), t1.name from scientists as t1 join assignedto as t2 on t1.ssn = t2.scientist group by t1.name