Can you show the hours they each worked too, please?
SELECT T1.Name ,  T3.Name ,  T3.Hours FROM Scientists AS T1 JOIN AssignedTo AS T2 ON T1.SSN  =  T2.Scientist JOIN Projects AS T3 ON T2.Project  =  T3.Code ORDER BY T3.Name ,  T1.Name
show the hours = SELECT Hours; they each worked = JOIN on entities involving Scientists, AssignedTo, and Projects;