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