CREATE TABLE table_22977424_8 (season VARCHAR2, promoted_from_league VARCHAR2)

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