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_93 (author VARCHAR, company VARCHAR)
system
Which Author's Company is Ruth Kanner Theatre Group?
user
SELECT author FROM table_name_93 WHERE company = "ruth kanner theatre group"
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_93 (author VARCHAR, company VARCHAR)<|im_end|>
<|im_start|>user
Which Author's Company is Ruth Kanner Theatre Group?<|im_end|>
