What is the branch ID associated with Myron Pryor?
SELECT t2.branch_id from member as t1 join purchase as t2 on t1.member_id  =  t2.member_id where name  =  "Myron Pryor"
branch ID associated with Myron Pryor requires joining member and purchase tables on member_id and filtering where name = 'Myron Pryor';