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 member's Name, Hometown of the results of step 1 whose Open_year equals 2016
Output (English): SELECT T1.Name , T1.Hometown 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 WHERE T2.Open_year = 2016