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 the summation of Hours of each value of Project in the results of step 1.
Step 3: find Projects's Name, Scientists's Name of the results of step 1 with largest value in the results of step 2
Output (English): SELECT T2.Name , T1.Name FROM Scientists AS T1 JOIN Projects AS T2 JOIN AssignedTo AS T3 ON T1.SSN = T3.Scientist AND T3.Project = T2.Code AND T1.SSN = T3.Scientist GROUP BY T3.Project ORDER BY Sum ( T2.Hours ) Desc LIMIT 1