Who are the students?
select * from student
What are their distinct majors?
select distinct major from student