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_51 (opposition VARCHAR, year VARCHAR, venue VARCHAR)
system
Which Opposition has a Year smaller than 1911, and a Venue of old trafford?
user
SELECT opposition FROM table_name_51 WHERE year < 1911 AND venue = "old trafford"
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_51 (opposition VARCHAR, year VARCHAR, venue VARCHAR)<|im_end|>
<|im_start|>user
Which Opposition has a Year smaller than 1911, and a Venue of old trafford?<|im_end|>
