What are the names of the scientists, and how many projects are each of them working on?
select count(*), t1.name from scientists as t1 join assignedto as t2 on t1.ssn = t2.scientist group by t1.name