Task: Text to Code
Input (English): Step 1: For each row in membership_register_branch table, find corresponding rows in member table and in branch table.
Step 2: find branch's Name, member's Name of the results of step 1 whose Register_Year greater than 2015
Output (English): SELECT T2.Name , T1.Name FROM member AS T1 JOIN branch AS T2 JOIN membership_register_branch AS T3 ON T1.Member_ID = T3.Member_ID AND T3.Branch_ID = T2.Branch_ID AND T1.Member_ID = T3.Member_ID WHERE T3.Register_Year > 2015