What is the name of the branch with the greatest amount of memberships that were registered in the year 2016?
select t2.name from membership_register_branch as t1 join branch as t2 on t1.branch_id = t2.branch_id where t1.register_year = 2016 group by t2.branch_id order by count ( * ) desc limit 1
What is the year that branch opened?
select t2.open_year from membership_register_branch as t1 join branch as t2 on t1.branch_id = t2.branch_id where t1.register_year = 2016 group by t2.branch_id order by count ( * ) desc limit 1
Can you list the name and membership amount of the branch that had the least amount of memberships that were opened in the year 2017?
select name, membership_amount from branch where membership_amount = ( select min ( membership_amount ) from branch where open_year like "%2017%" )
Can you list the name and opening year of the branch that opened the earliest?
select name, open_year from branch where open_year = ( select min ( open_year ) from branch )