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, Hours, Scientists's Name of the results of step 1 ordered ascending by Projects's Name
Output (English): SELECT T2.Name , T2.Hours , T1.Name FROM Scientists AS T1 JOIN Projects AS T2 JOIN AssignedTo AS T3 ON T1.SSN = T3.Scientist AND T3.Project = T2.Code ORDER BY T2.Name Asc