SELECT count(DISTINCT scientist) FROM assignedto
Count the number of different scientists assigned to any project.
SELECT count ( DISTINCT scientist ) FROM assignedto
select count ( distinct scientist ) from assignedto
Count the number of different scientists assigned to any project .