Which Advisor has most of students? List advisor and the number of students.
CREATE TABLE restaurant_type (
    restypeid number,
    restypename text,
    restypedescription text
)

CREATE TABLE type_of_restaurant (
    resid number,
    restypeid number
)

CREATE TABLE restaurant (
    resid number,
    resname text,
    address text,
    rating number
)

CREATE TABLE visits_restaurant (
    stuid number,
    resid number,
    time time,
    spent number
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)
SELECT advisor, COUNT(*) FROM student GROUP BY advisor ORDER BY COUNT(advisor) 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: Which Advisor has most of students? List advisor and the number of students. ### Input: CREATE TABLE restaurant_type (
    restypeid number,
    restypename text,
    restypedescription text
)

CREATE TABLE type_of_restaurant (
    resid number,
    restypeid number
)

CREATE TABLE restaurant (
    resid number,
    resname text,
    address text,
    rating number
)

CREATE TABLE visits_restaurant (
    stuid number,
    resid number,
    time time,
    spent number
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
) ### Response: SELECT advisor, COUNT(*) FROM student GROUP BY advisor ORDER BY COUNT(advisor) DESC LIMIT 1