CREATE TABLE member_of_club (stuid NUMBER, clubid NUMBER, position CLOB)
CREATE TABLE club (clubid NUMBER, clubname CLOB, clubdesc CLOB, clublocation CLOB)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)

Which club has the most members majoring in '600'?
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.major = "600" 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 "600" = "t3"."major" AND "t2"."stuid" = "t3"."stuid" GROUP BY "t1"."clubname" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY