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_name_1 (term_of_office VARCHAR, electorate VARCHAR)
system
What was the term of office for the electorate warringah?
user
SELECT term_of_office FROM table_name_1 WHERE electorate = "warringah"
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_name_1 (term_of_office VARCHAR, electorate VARCHAR)<|im_end|>
<|im_start|>user
What was the term of office for the electorate warringah?<|im_end|>
