How many cities have a branch with 100 membership?
select count ( distinct city ) from branch where membership_amount > 100
show all the branches opened in 2000?
select branch_id from branch where open_year = 2000
Which year was Stanley open?
select open_year from branch where name = "Stanley"
What is the address road of Stanley?
select address_road from branch where name = "Stanley"