Task: Text to Code
Input (English): Step 1: For each row in Movie table, find the corresponding rows in Rating table.
Step 2: find director of the results of step 1 whose stars equals 2.
Step 3: For each row in Reviewer table, find the corresponding rows in Rating table.
Step 4: find name, stars of the results of step 3 whose stars equals 5.
Step 5: show the rows that are in both the results of step 2 and the results of step 4
Output (English): SELECT T1.director FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID = T2.mID WHERE T2.stars = 2 INTERSECT SELECT T3.name , T2.stars FROM Reviewer AS T3 JOIN Rating AS T2 ON T3.rID = T2.rID WHERE T2.stars = 5