How many clubs do you have?
select count ( * ) from club
How many members does each club have?
select clubid, count ( stuid ) from member_of_club group by clubid
Finally, can you list the clubs that have "Davis Steven" as a member?
select t1.clubid from member_of_club as t1 join student as t2 on t1.stuid = t2.stuid where t2.lname = 'Davis' and t2.fname = 'Steven'