SELECT Major FROM STUDENT WHERE Sex = "F" GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1
Apa jurusan paling umum di antara siswa (seks adalah f) siswa?
CREATE TABLE STUDENT (Major VARCHAR, major VARCHAR, Sex VARCHAR)