Table schema:
CREATE TABLE student (fname VARCHAR, lname VARCHAR, major VARCHAR)

Question: 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)