Translate the following question to SQL: Which advisor has most number of students?

Schema: CREATE TABLE Allergy_Type (
    Allergy VARCHAR(20)   PRIMARY KEY,
    AllergyType VARCHAR(20),
    UNIQUE (Allergy)
);

CREATE TABLE Has_Allergy (
    StuID INTEGER,
    Allergy VARCHAR(20),
    FOREIGN KEY (Allergy) REFERENCES Allergy_Type(Allergy),
    FOREIGN KEY (StuID) REFERENCES Student(StuID)
);

CREATE TABLE Student (
    StuID INTEGER   PRIMARY KEY,
    LName VARCHAR(12),
    Fname VARCHAR(12),
    Age INTEGER,
    Sex VARCHAR(1),
    Major INTEGER,
    Advisor INTEGER,
    city_code VARCHAR(3)
);
user
SELECT advisor FROM Student GROUP BY advisor ORDER BY count(*) DESC LIMIT 1
assistant