What was the home team's record when they played the Devil Rays on September 6?
CREATE TABLE table_name_50 (record VARCHAR, opponent VARCHAR, date VARCHAR)
SELECT record FROM table_name_50 WHERE opponent = "devil rays" AND date = "september 6"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (record VARCHAR, opponent VARCHAR, date VARCHAR) Question: What was the home team's record when they played the Devil Rays on September 6? [/INST] SELECT record FROM table_name_50 WHERE opponent = "devil rays" AND date = "september 6" </s>