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_41 (week INTEGER, date VARCHAR, attendance VARCHAR)
system
Who was the opponent on the date of November 29, 1970 and the attendance was less than 31,427?
user
SELECT AVG(week) FROM table_name_41 WHERE date = "november 29, 1970" AND attendance < 31 OFFSET 427
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_41 (week INTEGER, date VARCHAR, attendance VARCHAR)<|im_end|>
<|im_start|>user
Who was the opponent on the date of November 29, 1970 and the attendance was less than 31,427?<|im_end|>
