CREATE TABLE table_name_50 (record VARCHAR, opponent VARCHAR, date VARCHAR)

What was the home team's record when they played the Devil Rays on September 6?
SELECT record FROM table_name_50 WHERE opponent = "devil rays" AND date = "september 6"
SELECT "record" FROM "table_name_50" WHERE "date" = "september 6" AND "devil rays" = "opponent"