CREATE TABLE member (member_id NUMBER, card_number CLOB, name CLOB, hometown CLOB, level NUMBER)
CREATE TABLE branch (branch_id NUMBER, name CLOB, open_year CLOB, address_road CLOB, city CLOB, membership_amount CLOB)
CREATE TABLE purchase (member_id NUMBER, branch_id CLOB, year CLOB, total_pounds NUMBER)
CREATE TABLE membership_register_branch (member_id NUMBER, branch_id CLOB, register_year CLOB)

What are the names of the branches that have some members with a hometown in Louisville, Kentucky and also those from Hiram, Goergia?
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' INTERSECT 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 = 'Hiram ,  Georgia'
SELECT "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" AND "T3"."hometown" = 'Louisville ,  Kentucky' INTERSECT SELECT "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" AND "T3"."hometown" = 'Hiram ,  Georgia'