CREATE TABLE member (name VARCHAR(255), member_id VARCHAR(255)); CREATE TABLE membership_register_branch (branch_id VARCHAR(255), member_id VARCHAR(255), register_year VARCHAR(255)); CREATE TABLE branch (name VARCHAR(255), branch_id VARCHAR(255))
Show all member names and registered branch names sorted by register year.
    
SQL: SELECT T3.name, T2.name FROM membership_register_branch AS T1 JOIN branch AS T2 ON T1.branch_id = T2.branch_id JOIN member AS T3 ON T1.member_id = T3.member_id ORDER BY T1.register_year