list all of the different majors.
select distinct major from student
which major has the fewest students?
select major from student group by major order by count(*) limit 1
what is the most popular major?
select major from student group by major order by count(*) desc limit 1
how many students are not this major?
select count(*) from student where major != (select major from student group by major order by count(*) desc limit 1)
show their first and last names.
select fname, lname from student where major != (select major from student group by major order by count(*) desc limit 1)