Tell me the number of females in club "Hopkins Student Enterprises".
select count(*) from club as t1 join member_of_club as t2 on t1.clubid = t2.clubid join student as t3 on t2.stuid = t3.stuid where t1.clubname = "Hopkins student Enterprises" and t3.sex = "F"
How about that of the members with age > 18?
select count(*) from club as t1 join member_of_club as t2 on t1.clubid = t2.clubid join student as t3 on t2.stuid = t3.stuid where t1.clubname = "Hopkins student Enterprises" and t3.age > 18
I want to know the average age of members in that club.
select avg(t3.age) from club as t1 join member_of_club as t2 on t1.clubid = t2.clubid join student as t3 on t2.stuid = t3.stuid where t1.clubname = "Hopkins student Enterprises"