Translate the following question to SQL: What are the names of each scientist, the names of the projects that they work on, and the hours for each of those projects, listed in alphabetical order by project name, then scientist name.

Schema: CREATE TABLE Scientists (
    SSN INT   PRIMARY KEY,
    Name Char(30) NOT NULL,
    UNIQUE (SSN)
);

CREATE TABLE Projects (
    Code Char(4)   PRIMARY KEY,
    Name Char(50) NOT NULL,
    Hours INT,
    UNIQUE (Code)
);

CREATE TABLE AssignedTo (
    Scientist INT NOT NULL  PRIMARY KEY,
    Project char(4) NOT NULL  PRIMARY KEY,
    PRIMARY KEY (Scientist, Project),
    UNIQUE (Scientist, Project),
    FOREIGN KEY (Project) REFERENCES Projects(Code),
    FOREIGN KEY (Scientist) REFERENCES Scientists(SSN)
);
user
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
assistant