Database: shop_membership
Question: What are the names of the members and branches at which they are registered sorted by year of registration?
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