Task: Text to Code
Input (English): Find the first and last name of students who are not in the largest major.
Output (English): SELECT fname ,  lname FROM student WHERE major != (SELECT major FROM student GROUP BY major ORDER BY count(*) DESC LIMIT 1)