What are the majors of male (sex is M) students?
select major from student where sex = "M"