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

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 FETCH FIRST 1 ROWS ONLY)