Task: Text to Code
Input (English): Step 1: For each row in Rating table, find corresponding rows in Movie table and in Reviewer table.
Step 2: find title of the results of step 1 whose name equals James Cameron and year greater than 2000
Output (English): SELECT T1.title FROM Movie AS T1 JOIN Reviewer AS T2 JOIN Rating AS T3 ON T1.mID = T3.mID AND T3.rID = T2.rID WHERE T2.name = "James Cameron" AND T1.year > 2000