Show all majors and corresponding number of students.
CREATE TABLE allergy_type (
    allergy text,
    allergytype text
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE has_allergy (
    stuid number,
    allergy text
)
SELECT major, COUNT(*) FROM student GROUP BY major
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: Show all majors and corresponding number of students. ### Input: CREATE TABLE allergy_type (
    allergy text,
    allergytype text
)

CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE has_allergy (
    stuid number,
    allergy text
) ### Response: SELECT major, COUNT(*) FROM student GROUP BY major