SELECT fname ,  lname FROM student WHERE major != (SELECT major FROM student GROUP BY major ORDER BY count(*) DESC LIMIT 1)
What is the first and last name of the students who are not in the largest major?
SELECT fname , lname FROM student WHERE major ! = ( SELECT major FROM student GROUP BY major ORDER BY count ( * ) DESC LIMIT 1 )
select fname , lname from student where major ! = ( select major from student group by major order by count ( * ) desc limit value )
What is the first and last name of the students who are not in the largest major ?