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_21 (height__cm_ INTEGER, weight__kg_ VARCHAR, birthdate VARCHAR)
system
What is the height of the player born on June 24, 1964, with a weight over 84 kg?
user
SELECT AVG(height__cm_) FROM table_name_21 WHERE weight__kg_ > 84 AND birthdate = "june 24, 1964"
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_21 (height__cm_ INTEGER, weight__kg_ VARCHAR, birthdate VARCHAR)<|im_end|>
<|im_start|>user
What is the height of the player born on June 24, 1964, with a weight over 84 kg?<|im_end|>
