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_1157867_2 (date_built VARCHAR, wheel_arrangement VARCHAR, builder VARCHAR)
system
On what date did Hudswell Clarke build the locomotive with 0-6-0 ST wheel arrangements?
user
SELECT date_built FROM table_1157867_2 WHERE wheel_arrangement = "0-6-0 ST" AND builder = "Hudswell Clarke"
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_1157867_2 (date_built VARCHAR, wheel_arrangement VARCHAR, builder VARCHAR)<|im_end|>
<|im_start|>user
On what date did Hudswell Clarke build the locomotive with 0-6-0 ST wheel arrangements?<|im_end|>
