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_95 (gender VARCHAR, decile VARCHAR, area VARCHAR)
system
What gender is the team that has a decile of 5 and in the Dalefield area?
user
SELECT gender FROM table_name_95 WHERE decile = 5 AND area = "dalefield"
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_95 (gender VARCHAR, decile VARCHAR, area VARCHAR)<|im_end|>
<|im_start|>user
What gender is the team that has a decile of 5 and in the Dalefield area?<|im_end|>
