user: ### NOW ANSWER:
Question: Name the season for Rotherham Titans
Columns: ['Season', 'Name', 'Teams', 'Relegated to League', 'Promoted to League', 'Promoted from League', 'Relegated from League']
Types: ['text', 'text', 'real', 'text', 'text', 'text', 'text']
Sample row: ['1996–97', 'Courage Championship Division One', 12.0, 'None', 'Coventry Rugby Lions Rotherham Richmond', 'Richmond Newcastle Falcons', 'Rugby Lions Nottingham']
SQL:

assistant: SELECT "Season" FROM "Table" WHERE "Promoted from League" = 'Rotherham Titans';