List all the scientists' names and their projects' names
select t1.name, t3.name from scientists as t1 join assignedto as t2 on t1.ssn = t2.scientist join projects as t3 on t2.project = t3.code
show the hours worked by them on each project.
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
list the results in alphabetical order of project name, and then scientist name.
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