CREATE TABLE assignedto (scientist NUMBER, project CLOB)
CREATE TABLE projects (code CLOB, name CLOB, hours NUMBER)
CREATE TABLE scientists (ssn NUMBER, name CLOB)

List all the scientists' names, their projects' names, and the hours worked by that scientist on each project, 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
SELECT "T1"."name", "T3"."name", "T3"."hours" FROM "scientists" "T1" JOIN "assignedto" "T2" ON "T1"."ssn" = "T2"."scientist" JOIN "projects" "T3" ON "T2"."project" = "T3"."code" ORDER BY "T3"."name", "T1"."name"