Find the semester and year which has the least number of student taking any class.
CREATE TABLE takes (semester VARCHAR, YEAR VARCHAR)
SELECT TOP 1 semester, YEAR FROM takes GROUP BY semester, YEAR ORDER BY COUNT(*)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE takes (semester VARCHAR, YEAR VARCHAR) Question: Find the semester and year which has the least number of student taking any class. [/INST] SELECT TOP 1 semester, YEAR FROM takes GROUP BY semester, YEAR ORDER BY COUNT(*) </s>