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_54 (viewers__m_ INTEGER, rating VARCHAR, episode VARCHAR)
system
What Viewers (m) has a Rating of 1.7, and an Episode of the game of life?
user
SELECT MAX(viewers__m_) FROM table_name_54 WHERE rating = "1.7" AND episode = "the game of life"
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_54 (viewers__m_ INTEGER, rating VARCHAR, episode VARCHAR)<|im_end|>
<|im_start|>user
What Viewers (m) has a Rating of 1.7, and an Episode of the game of life?<|im_end|>
