CREATE TABLE student (fname VARCHAR(255), lname VARCHAR(255), major VARCHAR(255))
Find the first and last name of students who are not in the largest major.
    
SQL: SELECT fname, lname FROM student WHERE major <> (SELECT major FROM student GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1)