Find the first and last name of students who are not in the largest major.
create table student (fname varchar, lname varchar, major varchar, PRIMARY KEY (fname))
select fname, lname from student where major <> (select major from student group by major order by count(*) limit 1)