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 year greater than 1980 or name equals James Cameron
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 T1.year > 1980 OR T2.name = "James Cameron"