How many sports do we have?
CREATE TABLE Sportsinfo (sportname VARCHAR)
SELECT COUNT(DISTINCT sportname) FROM Sportsinfo
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Sportsinfo (sportname VARCHAR) Question: How many sports do we have? [/INST] SELECT COUNT(DISTINCT sportname) FROM Sportsinfo </s>