CREATE TABLE membership_register_branch (branch_id VARCHAR2, member_id VARCHAR2, register_year VARCHAR2)
CREATE TABLE member (name VARCHAR2, member_id VARCHAR2)
CREATE TABLE branch (name VARCHAR2, branch_id VARCHAR2)

Show all member names and registered branch names sorted by register year.
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
SELECT "T3"."name", "T2"."name" FROM "membership_register_branch" "T1" JOIN "branch" "T2" ON "T1"."branch_id" = "T2"."branch_id" JOIN "member" "T3" ON "T1"."member_id" = "T3"."member_id" ORDER BY "T1"."register_year"