Name the season for rotherham titans
CREATE TABLE table_22977424_8 (season VARCHAR, promoted_from_league VARCHAR)
SELECT season FROM table_22977424_8 WHERE promoted_from_league = "Rotherham Titans"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_22977424_8 (season VARCHAR, promoted_from_league VARCHAR) Question: Name the season for rotherham titans [/INST] SELECT season FROM table_22977424_8 WHERE promoted_from_league = "Rotherham Titans" </s>