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_24575253_4 (division_five VARCHAR, division_one VARCHAR)
system
When westcott is in division one how many leagues are in division 5?
user
SELECT COUNT(division_five) FROM table_24575253_4 WHERE division_one = "Westcott"
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_24575253_4 (division_five VARCHAR, division_one VARCHAR)<|im_end|>
<|im_start|>user
When westcott is in division one how many leagues are in division 5?<|im_end|>
