How many players enter hall of fame each year?
CREATE TABLE hall_of_fame (yearid VARCHAR)
SELECT yearid, COUNT(*) FROM hall_of_fame GROUP BY yearid
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE hall_of_fame (yearid VARCHAR) Question: How many players enter hall of fame each year? [/INST] SELECT yearid, COUNT(*) FROM hall_of_fame GROUP BY yearid </s>