CREATE TABLE student (fname VARCHAR, lname VARCHAR, major VARCHAR)
Find the first and last name of 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)