You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE SECTION (semester VARCHAR, YEAR VARCHAR)
system
Find the year and semester when offers the largest number of courses.
user
SELECT semester, YEAR FROM SECTION GROUP BY semester, YEAR ORDER BY COUNT(*) DESC LIMIT 1
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE SECTION (semester VARCHAR, YEAR VARCHAR)<|im_end|>
<|im_start|>user
Find the year and semester when offers the largest number of courses.<|im_end|>
