Given  the branches are Alexandre, Popert, Stanley, Zytogorski, Cochrane, Taverner, Saint Amant, and Brooke Greville, which have members in Louisville, Kentucky?
SELECT 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 WHERE T3.Hometown   =   'Louisville, Kentucky'
branches with members in a specific location requires JOINs across membership, branch, and member tables; filtering by a specific hometown (Louisville, Kentucky) is done through a WHERE clause on the member's hometown.