Find the first and last name of students who are not in the largest major.
CREATE TABLE student (fname VARCHAR, lname VARCHAR, major VARCHAR)
SELECT fname, lname FROM student WHERE major <> (SELECT TOP 1 major FROM student GROUP BY major ORDER BY COUNT(*) DESC)
<s>[INST] Write mssql query to answer the following question given the database schema. 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. [/INST] SELECT fname, lname FROM student WHERE major <> (SELECT TOP 1 major FROM student GROUP BY major ORDER BY COUNT(*) DESC) </s>