Give distinct majors.
select distinct major from student
Which has the most number of students?
select major from student group by major order by count(major) desc limit 1;
Which has the least?
select major from student group by major order by count(major) asc limit 1;
Give the count to prove it.
select major, count(*) from student group by major order by count(major) asc limit 1;