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 major FROM student GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the first and last name of students who are not in the largest major. ### Input: CREATE TABLE student (
    fname VARCHAR,
    lname VARCHAR,
    major VARCHAR
) ### Response: SELECT fname, lname FROM student WHERE major <> (SELECT major FROM student GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1)