Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE assignedto ( scientist number, project text )
TABLE: CREATE TABLE projects ( code text, name text, hours number )
TABLE: CREATE TABLE scientists ( ssn number, name text )

### Question ###
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.

### Accurate SQL ###

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