How many purchases are there in file?
select count(*) from purchase
Show me the id of members with level 6.
select member_id from member where level = 6
How many purchases are for any of those members?
select count(*) from purchase as t1 join member as t2 on t1.member_id = t2.member_id where t2.level = 6