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_88 (commissioned VARCHAR, builder VARCHAR)
system
when was it commissioned when the destroyer was built by scotts, greenock?
user
SELECT commissioned FROM table_name_88 WHERE builder = "scotts, greenock"
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_88 (commissioned VARCHAR, builder VARCHAR)<|im_end|>
<|im_start|>user
when was it commissioned when the destroyer was built by scotts, greenock?<|im_end|>
