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_77 (suffix VARCHAR, prefix VARCHAR)
system
Which item has the suffix containing thiocyanato- (-scn) as a prefix?
user
SELECT suffix FROM table_name_77 WHERE prefix = "thiocyanato- (-scn)"
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_77 (suffix VARCHAR, prefix VARCHAR)<|im_end|>
<|im_start|>user
Which item has the suffix containing thiocyanato- (-scn) as a prefix?<|im_end|>
