Show the student IDs and numbers of friends corresponding to each.
CREATE TABLE Friend (student_id VARCHAR)
SELECT student_id, COUNT(*) FROM Friend GROUP BY student_id
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Friend (student_id VARCHAR) Question: Show the student IDs and numbers of friends corresponding to each. [/INST] SELECT student_id, COUNT(*) FROM Friend GROUP BY student_id </s>