CREATE TABLE club (clubname VARCHAR2, clubid VARCHAR2)
CREATE TABLE member_of_club (clubid VARCHAR2, stuid VARCHAR2)
CREATE TABLE student (stuid VARCHAR2, sex VARCHAR2)

Find the name of the club that has the most female students.
SELECT t1.clubname 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 t3.sex = "F" GROUP BY t1.clubname ORDER BY COUNT(*) DESC LIMIT 1
SELECT "t1"."clubname" FROM "club" "t1" JOIN "member_of_club" "t2" ON "t1"."clubid" = "t2"."clubid" JOIN "student" "t3" ON "F" = "t3"."sex" AND "t2"."stuid" = "t3"."stuid" GROUP BY "t1"."clubname" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY