Table schema:
CREATE TABLE table_22977424_8 (season VARCHAR, promoted_from_league VARCHAR)

Question: Name the season for rotherham titans
SQL: SELECT season FROM table_22977424_8 WHERE promoted_from_league = "Rotherham Titans"