Task: Text to Code
Input (English): Step 1: For each row in AssignedTo table, find corresponding rows in Scientists table and in Projects table.
Step 2: find Projects's Name, Scientists's Name, Hours of the results of step 1 ordered ascending by Scientists's Name
Output (English): SELECT T2.Name , T1.Name , T2.Hours FROM Scientists AS T1 JOIN Projects AS T2 JOIN AssignedTo AS T3 ON T1.SSN = T3.Scientist AND T3.Project = T2.Code ORDER BY T1.Name Asc