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 name, title, title of the results of step 1 ordered ascending by stars
Output (English): SELECT T2.name , T1.title , T1.title FROM Movie AS T1 JOIN Reviewer AS T2 JOIN Rating AS T3 ON T1.mID = T3.mID AND T3.rID = T2.rID AND T1.mID = T3.mID ORDER BY T3.stars Asc