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_1147705_1 (engine_displacement VARCHAR, engine_type VARCHAR)
system
What is the engine displacement for the engine type b5254 t?
user
SELECT engine_displacement FROM table_1147705_1 WHERE engine_type = "B5254 T"
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_1147705_1 (engine_displacement VARCHAR, engine_type VARCHAR)<|im_end|>
<|im_start|>user
What is the engine displacement for the engine type b5254 t?<|im_end|>
