Database: dorm_1
Question: What is the first and last name of the 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)