When the team is the Boston Red Sox and the is date July 27, 1946, what are the average RBIs?
CREATE TABLE table_name_79 (rbis INTEGER, team VARCHAR, date VARCHAR)
SELECT AVG(rbis) FROM table_name_79 WHERE team = "boston red sox" AND date = "july 27, 1946"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_79 (rbis INTEGER, team VARCHAR, date VARCHAR) Question: When the team is the Boston Red Sox and the is date July 27, 1946, what are the average RBIs? [/INST] SELECT AVG(rbis) FROM table_name_79 WHERE team = "boston red sox" AND date = "july 27, 1946" </s>