Show all majors and corresponding number of students.
CREATE TABLE Student (major VARCHAR)
SELECT major, COUNT(*) FROM Student GROUP BY major
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Student (major VARCHAR) Question: Show all majors and corresponding number of students. [/INST] SELECT major, COUNT(*) FROM Student GROUP BY major </s>