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 college (state VARCHAR, enr INTEGER)
system
What is the number of states that has some colleges whose enrollment is smaller than the average enrollment?
user
SELECT COUNT(DISTINCT state) FROM college WHERE enr < (SELECT AVG(enr) FROM college)
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 college (state VARCHAR, enr INTEGER)<|im_end|>
<|im_start|>user
What is the number of states that has some colleges whose enrollment is smaller than the average enrollment?<|im_end|>
