CREATE TABLE voting_record (stuid NUMBER, registration_date CLOB, election_cycle CLOB, president_vote NUMBER, vice_president_vote NUMBER, secretary_vote NUMBER, treasurer_vote NUMBER, class_president_vote NUMBER, class_senator_vote NUMBER)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)

Find the major that is studied by the most female students.
SELECT major FROM student WHERE sex = "F" GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1
SELECT "major" FROM "student" WHERE "F" = "sex" GROUP BY "major" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY