Count the number of likes for each student id.
CREATE TABLE Likes (student_id VARCHAR)
SELECT student_id, COUNT(*) FROM Likes GROUP BY student_id
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Likes (student_id VARCHAR) Question: Count the number of likes for each student id. [/INST] SELECT student_id, COUNT(*) FROM Likes GROUP BY student_id </s>