List the majors of female students.
select distinct major from student where sex = "F"
Order the majors by decreasing number of students.
select distinct major from student where sex = "F" group by major order by count(*) desc
What is the most common major?
select major from student where sex = "F" group by major order by count(*) desc limit 1