CREATE TABLE dorm (dormid DECIMAL, dorm_name TEXT, student_capacity DECIMAL, gender TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE dorm_amenity (amenid DECIMAL, amenity_name TEXT)
CREATE TABLE has_amenity (dormid DECIMAL, amenid DECIMAL)
CREATE TABLE lives_in (stuid DECIMAL, dormid DECIMAL, room_number DECIMAL)

Find the first and last name of students who are not in the largest major.
SELECT fname, lname FROM student WHERE major <> (SELECT major FROM student GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1)
SELECT "fname", "lname" FROM "student" WHERE "major" <> (SELECT "major" FROM "student" GROUP BY "major" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1)