the american football team earlier known as tennessee oilers is renamed as what?
(AND american_football.football_team (JOIN (R sports.defunct_sports_team.later_known_as) m.06f2k5d))