Find the number of projects which each scientist is working on and scientist's name.
SELECT count(*) ,  T1.name FROM scientists AS T1 JOIN assignedto AS T2 ON T1.ssn  =  T2.scientist GROUP BY T1.name
SELECT count(*) ,  T1.name FROM scientists AS T1 JOIN assignedto AS T2 ON T1.ssn  =  T2.scientist GROUP BY T1.name
[{'count(*)': 1, 'Name': 'Anand Manikutty'}, {'count(*)': 1, 'Name': 'Carol Smith'}, {'count(*)': 1, 'Name': 'David Smith'}, {'count(*)': 1, 'Name': 'Elizabeth Doe'}, {'count(*)': 1, 'Name': 'Eric Goldsmith'}, {'count(*)': 1, 'Name': 'George ODonnell'}, {'count(*)': 1, 'Name': 'Joe Stevens'}, {'count(*)': 1, 'Name': 'John Doe'}, {'count(*)': 1, 'Name': 'Kumar Swamy'}, {'count(*)': 1, 'Name': 'Mary-Anne Foster'}, {'count(*)': 1, 'Name': 'Michael Rogers'}, {'count(*)': 1, 'Name': 'Zacary Efron'}]