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_70 (total INTEGER, b_score VARCHAR, gymnast VARCHAR)
system
What is the total when the B Score was 9.15 for Cheng Fei ( chn )?
user
SELECT AVG(total) FROM table_name_70 WHERE b_score = 9.15 AND gymnast = "cheng fei ( chn )"
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_70 (total INTEGER, b_score VARCHAR, gymnast VARCHAR)<|im_end|>
<|im_start|>user
What is the total when the B Score was 9.15 for Cheng Fei ( chn )?<|im_end|>
