Task: Text to Code
Input (English): Step 1: For each row in Reviewer table, find the corresponding rows in Rating table.
Step 2: find name, stars of the results of step 1 whose stars equals 2.
Step 3: For each row in Movie table, find the corresponding rows in Rating table.
Step 4: find director 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.name , T2.stars FROM Reviewer AS T1 JOIN Rating AS T2 ON T1.rID = T2.rID WHERE T2.stars = 2 INTERSECT SELECT T3.director FROM Movie AS T3 JOIN Rating AS T2 ON T3.mID = T2.mID WHERE T2.stars = 5