What is the total number of purchases for members with level 6?
select count ( * ) from purchase as t1 join member as t2 on t1.member_id = t2.member_id where t2.level = 6
Which 2 members have the highest number of purchases?
select t2.name from purchase as t1 join member as t2 on t1.member_id = t2.member_id group by t1.member_id order by count ( * ) desc limit 2
What is the hometown of Myron Pryor?
select hometown from member where name = "Myron Pryor"
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"