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 table_2522473_1 (team VARCHAR, seasons VARCHAR)
system
How many teams have been in Topperserien for 8 seasons? 
user
SELECT COUNT(team) FROM table_2522473_1 WHERE seasons = 8
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 table_2522473_1 (team VARCHAR, seasons VARCHAR)<|im_end|>
<|im_start|>user
How many teams have been in Topperserien for 8 seasons? <|im_end|>
