yes, list the project codes, names, and hours worked by scientists by ssn
select t3.name, t3.code, 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 t1.ssn
list scientists names by ssn
select name from scientists order by ssn
list Project codes, names, and hours worked by scientist by ssn and name
select t3.code, 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 t1.ssn
list results by scientists name
select t3.code, 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 t1.name
yes
select t3.name from scientists as t1 join assignedto as t2 on t1.ssn = t2.scientist join projects as t3 on t2.project = t3.code order by t1.name
list project names in ascending order
select t3.name from scientists as t1 join assignedto as t2 on t1.ssn = t2.scientist join projects as t3 on t2.project = t3.code order by t1.name asc