What is the name of school that has the smallest enrollment in each state?
CREATE TABLE college (cName VARCHAR, state VARCHAR, enr INTEGER)
SELECT cName, state, MIN(enr) FROM college GROUP BY state
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE college (cName VARCHAR, state VARCHAR, enr INTEGER) Question: What is the name of school that has the smallest enrollment in each state? [/INST] SELECT cName, state, MIN(enr) FROM college GROUP BY state </s>