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_82 (game VARCHAR, year VARCHAR, genre VARCHAR)
system
What game was before 2010 and was a role-playing game?
user
SELECT game FROM table_name_82 WHERE year < 2010 AND genre = "role-playing game"
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_82 (game VARCHAR, year VARCHAR, genre VARCHAR)<|im_end|>
<|im_start|>user
What game was before 2010 and was a role-playing game?<|im_end|>
